Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “abohms” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

293 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
abohms133500(None) 
abohm1247971abohm_
abhors11410622abhors
abmhos1334972abmhos
abodes94417512abodes
aboma91114602abo_ma
abomas101113582abomas
aborts84916182aborts
abos67734412abo__s
aboves114512842aboves
abysms13565652abysms
alohas9411702alohas
atoms76817562ato_ms
bohos105618252_bohos
booms95427122_booms
ohms95514032__ohms
aahs716428563a_ah_s
abacas104414723abacas
abacus10349763abacus
abakas123911743abakas
abamp11310603ab_amp
abamps1236253abamps
abas68642083ab__as
abases85720773abases
abashes12510373abashes
abates85825033abates
abatis84317933abatis
abayas114011703abayas
abbas95918643ab_bas
abbes96723523ab_bes
abbess10509773abbess
abbeys13538423abbeys
abbots1039283abbots
abeam9316533abeam_
abeles84719393abeles
abets75621673ab_ets
abhor10411063ab_hor
abides94719893abides
abioses9311493abioses
abiosis939373abiosis
ables75935543ab_les
ablins8316193ablins
abloom1039783abloom_
abmho1236793abmh_o
abo59045963abo___
aboard9312613aboard
abode85518813abo_de
aboded104912513aboded
aboil72217543abo_il
abolish12311503abolish
abolla8410193abolla
abomasa11114613abomasa
abomasi11115493abomasi
aboon74918703abo_on
aboral8314373aboral
abort76133583abo_rt
abortus9397913abortus
abound9239863abound
abounds10217083abounds
about75229083abo_ut
above105414323abo_ve
abris75722603ab_ris
abs59356073ab___s
absorbs1135603absorbs
abuses85119103abuses
abuts75417073ab_uts
abvolts12104373abvolts
abyes105518533ab_yes
abys97221883ab__ys
abysm12598143abysm_
abyss10669463ab_yss
aches106132293a_ches
acorns85013013acorns
adeems946333adeems
adobes94411523adobes
adobos9438453adobos
adonis7314063adonis
adopts998083adopts
adores74420713adores
adorns74212613adorns
ados57633513ado__s
aeons57624653aeo_ns
aghas97014873a_ghas
agisms9399393agisms
agones75719863agones
agons66423783ago_ns
agoras7613343agoras
ahis76135383a__his
aholds10469483aholds
ahs68644823a__h_s
aims67738183a__ims
aiolis6316843aiolis
alarms85913053alarms
albums10198273albums
algums9208043algums
alms65834923a__lms
aloes54933673alo_es
aloha8513613aloh_a
aloins65022203aloins
alphas1139513alphas
alums75720603a_lums
amahs107819063amah_s
ambones11312683ambones
ambos95321243ambo__s
amoks11413553amo_ks
amoles84122193amoles
amours83512643amours
anchos114214893anchos
ankhs12116723ankh_s
anoas57226493ano_as
anodes74418753anodes
anoles64827423anoles
anomy105113393ano_my
anonyms1235443anonyms
anthems12309423anthems
aphis105917133a_phis
apods86316343apo_ds
apos65433823apo__s
apothems1544223apothems
arbores94016033arbores
arbors84717873arbo_rs
arbours93910033arbours
arches114822043arches
arms66137493a__rms
aroids75118223aroids
aroma71220143aro_ma
aromas81018613aromas
arums75517833a_rums
ashes86230613a_shes
asthma11126563asthma
asthmas12117363asthmas
atolls65511353atolls
atom67824523ato_m_
atomy107415193ato_my
atones65225773atones
aughts104710243aughts
aurums849383aurums
avoids104410203avoids
avos77227013avo__s
avows114910983avo_ws
awols84713523awo_ls
axioms15408053axioms
axones134614513axones
axons125517933axo_ns
ayahs116813523ayah_s
azoles154614613azoles
azons146518253azo_ns
azotes154312223azotes
azoths18366203azoths
babools11319453babools
baboons113211073baboons
baboos103517013babo_os
baches135426943baches
bahts105617803_bahts
balms95723923_balms
bams87044453_b_ams
barms96128463_barms
bashes115631393bashes
bathes116524833bathes
bathos116215633bathos
baths105922923bath_s
bazooms20285383bazooms
beams95328173_beams
berms95323663_berms
blams95023853_blams
blooms104613173blooms
boars75229603_boars
boas66150833_bo_as
boats75635153_boats
bobs86340643_bo_bs
boches134618523_boches
bocks134526573_bocks
bodes84935103_bodes
bods76244713_bo_ds
boffs134915503_boffs
bogs75742753_bo_gs
bogus85616473_bogus
bohea105013733_bohea
boheas114013213_boheas
boho96923323_boh_o
boils75427193_boils
bolas74733763_bolas
bolds85825283_bolds
boles75448603_boles
bolls75531313_bolls
bolos75531373_bolos
bolts76232113_bolts
bolus79125543_bolus
bomb106927423_bo_mb
bombs115818823_bombs
bonds86126843_bonds
bones76446533_bones
bongs87828423_bongs
bonks116326463_bonks
bonus75324323_bonus
boobs96221993_boobs
books115729713_books
boom87435673_boom_
boomy125421823_boomy
boons75031913_boons
boors74325013_boors
boos67955033_bo_os
boots75837973_boots
bops86037983_bo_ps
boras75938303_boras
bores76448253_bores
borks115727703_borks
borts76735453_borts
bos57966813_bo__s
boshes114721883_boshes
bosks115218853_bosks
bosoms104913043_bosoms
boss65938343_bo_ss
botas75328783_botas
bots66453953_bo_ts
botts75224863_botts
bouts75131313_bouts
bowls106121433_bowls
bows96242863_bo_ws
boxes145625073_boxes
boyos105418283_boyos
boys96737333_bo_ys
bozos165216863_bozos
brims94721623_brims
brooms104915873brooms
buhls105111803_buhls
buhrs104811243_buhrs
bums85934593_b_ums
cabobs124311883cabo_bs
caroms105619573caro_ms
cohos105921853_cohos
corms95626223_corms
doms76239573_do_ms
dooms85321343_dooms
dorms85723833_dorms
doums85417643_doums
ebons74316093ebo_ns
ebooks12358333ebooks
fathoms1537523fathoms
foams105017953_foams
fohns117310783_fohns
forms105327053_forms
gaboons10289893gaboons
gloams95210663gloams
gloms85219783glo_ms
glooms96211683glooms
gorms85619593_gorms
grooms94512523grooms
haboobs1495463haboobs
holms105117803_holms
jabots1538883jabo_ts
johns15398713_johns
kabobs14439293kabo_bs
khoums1594013khoums
kohls12437803_kohls
labors84016403labo_rs
labours9349883labours
labrums1175853labrums
loams75619863_loams
looms75124643_looms
megohms1592863megohms
moms86539483_mo_ms
nabobs10388203nabo_bs
noms65636403_no_ms
norms76019303_norms
oboes75717713obo_es
oboles83815833oboles
obols73715863obo_ls
obolus8378813obolus
ohm86523013__ohm_
ohs66232313__oh_s
oms56337513__o_ms
oohs75220693_ooh_s
pablums1345123pablums
poems95715553_poems
poms87037743_po_ms
poohs103915713pooh_s
proems104711163proems
proms95426403pro_ms
roams74919613_roams
roms67038963_ro_ms
rooms75324683_rooms
sabots8314693sabo_ts
soms66239373_so_ms
storms85814603storms
taboos83815423tabo_os
tabors84517093tabo_rs
tabours94110073tabours
toms68343493_to_ms
varooms1248883varooms
vrooms11398713vrooms
worms105320753_worms
zooms164415523_zooms

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.1401276364.3
2DLD Change Limit1127162936.25018034.6
3Display Results2932930.0933150.5
 (SQL Overall)1786912936.48327563.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.