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 “chromo” 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.

246 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
chromo13281101(None) 
chroma132912471chroma
chrome133214811chrome
chromos142610271chromos
chromy16309901chromy
bromo95217202_bromo
carom95025562carom_
caroms105619572caroms
chemo12313632ch_emo
cholo105217972ch_olo
chomp144815662ch_omp
chromas142512692chromas
chromed153510922chromed
chromes142914932chromes
chromic1639862chromic
chromous15258342chromous
chromyl17275232chromyl
chronon1237352chronon
homo96126472_h_omo
promo95620002_promo
achoo10315083ach_o_o
achromat15410103achromat
achromic1747613achromic
achromous1645463achromous
aroma71220143_aroma
arroyo936963arroyo
bichrome1745653bichrome
brome94421973_brome
bromos104213313_bromos
broo65129823_bro_o
broom95022213_broom
caeoma1039033caeoma
camo85731753c__amo
carbo94923843car_bo
cardio9915673cardio
cargo85322073car_go
carob95325223caro_b
carobs104818103carobs
caroch13911763caroch
carol75128613caro_l
caroli85918233caroli
carols85124983carols
caromed123713623caromed
carrom10513403carrom_
carroms11512403carroms
celom9515693celom_
celoms10412123celoms
cero66329453cer__o
ceros74726073cero_s
cerous85821203cerous
chacma1537903chacma
cham115532313ch_am_
chammy18488953chammy
champ145017963ch_amp
chams126028503ch_ams
chao95727313ch__ao
chaos105622863chao_s
charm126124663charm_
charms135218843charms
charro114212953charro
chasm125518793chasm_
chasms135513143chasms
chasmy16468543chasmy
chatroom1596263chatroom
cheapo134810083cheapo
cheero114712933cheero
chemos13311723chemos
cheroot12413693cheroot
chiao105618363ch_iao
chico124218253ch_ico
chimb144813563ch_imb
chime125322593ch_ime
chimp145216473ch_imp
chino105823313ch_ino
chirm125317063chirm_
chirms135113983chirms
chiro105320343ch_iro
chiros114617773chiro_s
chock164316613ch_ock
choir105313603ch_oir
choke145118023ch_oke
choky175711223ch_oky
chola104718033ch_ola
cholos114716853ch_olos
chomps155112223ch_omps
chon96627793ch_o_n
chook146015043ch_ook
chooks155312793chooks
choose115116143choose
choosy14459103choosy
chop116024923ch_o_p
chops125019873ch_ops
choral115118493choral
chord115917263ch_ord
chords125214633chords
chore105126763ch_ore
chorea115216093chorea
chored125321883chored
chores114828023chores
choric133515903choric
chorion12311773chorion
chorizo2136323chorizo
choroid13311803choroid
chorus115014773chorus
chose105925403ch_ose
chott103923933ch_ott
chow125820993ch_o_w
chows135618203ch_ows
chrism13710673chrism
chrisma1456823chrisma
chrismon1544643chrismon
chrisms1499143chrisms
chrisom1466623chrisom
chrisoms1566093chrisoms
chromate15312783chromate
chromide1648053chromide
chromier1538033chromier
chroming163410723chroming
chromite15310833chromite
chromium1745983chromium
chromize2447683chromize
chromogen1744893chromogen
chromyls18244733chromyls
chronic14311423chronic
chronons1347353chronons
chum116318003ch_um_
chummy18385893chummy
chump145315443ch_ump
chums125015833ch_ums
churro11448353churro
chyme156512503ch_yme
cleome1039083cleome
clomb115714703c_lomb
clomp115615703c_lomp
coco87330603c__oco
coho97524493c__oho
coma87134853c__oma
comb106632113c__omb
combo114519433c__ombo
come87547703c__ome
comp106731253c__omp
compo115318573c__ompo
coo59566363c__o_o
coomb115615703c_oomb
corm85735383cor_m_
corms95626223cor_ms
corody12149703corody
corona83817403corona
corymb1535223corymb
cram85635493c_ram_
crambo1238043c_rambo
cramp115120693c_ramp
crams96229153c_rams
credo84815573c_redo
creme94319323c_reme
crime94822693c_rime
crimp115615803c_rimp
croak115216633c_roak
croc85723733c_ro_c
croci95818133c_roci
crock135921993c_rock
crocs95722433c_rocs
croft105622683c_roft
crone75231333c_rone
crony105918673c_rony
crook115217573c_rook
croon75522783c_roon
crop87628633c_ro_p
crops96125233c_rops
crore74922873c_rore
cross75124503c_ross
croton84415453c_roton
croup95616783c_roup
crow96428133c_ro_w
crowd115815623c_rowd
crown105620083c_rown
crows105727313c_rows
croze164719453c_roze
crumb114313593c_rumb
crump115616423c_rump
curio74221213cur_io
dromon939363_dromon
duomo839753_duomo
from96923923_from_
groom85317983_groom
hobo97026083_h_obo
home98042443_h_ome
homos105921783_h_omos
homy126623223_h_omy
ihram10310183ihram_
ihrams1137173ihrams
iroko939663_iroko
karoo92519583karo_o
ochroid1357903ochroid
ochrous1237943ochrous
paramo102614643paramo
phono104917023ph_ono
photo104417233ph_oto
pomo85828453__pomo
primo95017913_primo
prom87631703_prom_
promos105116423_promos
proms95426413_proms
proso77222413_proso
rhomb12399803rh_omb
rom59855633__rom_
romeo73719703__romeo
romp85926573__romp
roms67038963__roms
room66235083__room
roto45935053__roto
schmo124510203sch__mo
schrod1247883schro_d
schrods1337433schrods
shmo95318103sh__mo
shoo75929893sh_o_o
shrimp13478773shrimp
shroff1538503shroff
shroud1038773shroud
shrove125412233shrove
stroma84313073stroma
thoro86217873th_oro
thro77726423thr__o
throat94819753throat
throb109816853thro_b
throbs118311373throbs
throe89321423thro_e
throes97518673throes
thrombi14134473thrombi
throne98517603throne
throng10539973throng
throve128012393throve
throw118719733thro_w
thrown1214911443thrown
throws129715233throws
thrum104713633thrum_
thrums11429123thrums
tromp95815803_tromp
varoom11411413varoom
vroom105312473_vroom
whammo16405193whammo
whamo135511263wh_amo
whom127018183wh_om_
whomp155011323wh_omp
whomso1434133wh_omso
whoso11509223wh_oso

Search took 6 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.376475242.0
2DLD Change Limit1127162464.98322620.1
3Display Results2462460.0803075.0
 (SQL Overall)1786912465.43932853.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.