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

513 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
achoo1031508(None) 
ahchoo1445711ahchoo
abhor10411062abhor
ache96829822ach_e
ached119227832ached
aches106132292aches
achy126316092ach_y
actor71116072actor
ahoy101919182a_hoy
ancho104515302anch_o
anchor113911972anchor
anchos114214892anchos
archon11311752archon
cachou13310612cachou
cahoot11416472cahoot
cahow135110942cahow
cashoo11312252cashoo
chao95727312_chao
cholo105217972_cholo
chon96627792_chon
chook146015042_chook
chop116024922_chop
chow125820992_chow
coho97524492_coho
coo59566362_c_oo
echo96615952ech_o
echos105216462echos
ichor1039472ichor
macho126120152mach_o
machos135217492machos
nacho105414382nach_o
nachos115014182nachos
schmo124510202schmo
school11410722school
shoo75929882_shoo
wahoo112413082wahoo
yahoo112911542yahoo
aah616252963aah__
aahed917816443aahed
aahs716428563aah_s
abbot9318453abbot
abhors11410623abhors
abloom1039783abloom
abmho1236793abmho
abmhos1334973abmhos
abo59045963a__bo
abohm1247973abohm
aboon74918703aboon
abos67734413a_bos
acajou1595233acajou
acari75020283acari
accord1178843accord
accost101112263accost
ace59656833ac__e
aced79540883ac_ed
acerb9312763acerb
aces67645093ac_es
aceta74017353aceta
achene11313813achene
achier113914263achier
aching126521973aching
achiote1239213achiote
acholia1239973acholia
acid77533393ac_id
acids87121003acids
acidy117214893acidy
acing87429153acing
acini75718983acini
ackee115825363ackee
acme86924323ac_me
acmes96020653acmes
acmic11312333acmic
acne66625873ac_ne
acned87520663acned
acnes75922623acnes
acnode938193acnode
acock132110213acock
acold86214923acold
acorn75616623acorn
acre67330773ac_re
acred87126353acred
acres76327763acres
acrid86920103acrid
across8312643across
act59557843ac__t
acta69524803ac_ta
acted88521733acted
actin74922553actin
action84719683action
actors81016753actors
acts66929863ac_ts
acute74720363acute
acyl95314293ac_yl
acyls104211523acyls
adios65822863adios
ado49146873a__do
adobo84711593adobo
ados57633513a_dos
aeon45634613a_eon
aero45435343a_ero
afoot8420113afoot
aggro738003aggro
agha87417303agh_a
aghas97014873aghas
agio57828453a_gio
agios65919863agios
aglow94711963aglow
ago48845523a__go
agog68019003a_gog
agon56531883a_gon
ah513868793a_h__
aha611246643a_h_a
ahed89536253a_hed
ahem97225363a_hem
ahi68040233a_h_i
ahis76135383a_his
ahold94714253a_hold
ahs68644823a_h_s
alamo7418143alamo
alcohol1244363alcohol
aldol61212333aldol
algor6513053algor
allod64418373allod
allot54933873allot
allow85420663allow
alloy85519973alloy
aloe45540193a_loe
aloha8513613aloha
aloof83521573aloof
alow75328593a_low
also46423443a_lso
altho86312603altho
alto47831263a_lto
altos55822953altos
ambo88225133a_mbo
ambos95321243ambos
amido85720963amido
amigo86515453amigo
amino75425493amino
ammo85520133a_mmo
ammono1047373ammono
ammos94815823ammos
amnio75218043amnio
amok10217403a_mok
anchors123912953anchors
anchovy1843953anchovy
ancon75718233ancon
andro6314163andro
anglo65215363anglo
anion55028813anion
annoy869713annoy
anoa45634473a_noa
anon46134853a_non
anyhow1544103anyhow
anyon85615223anyon
aphid115515393aphid
aphis105917133aphis
apo511142123a__po
apod78123183a_pod
apos65433823a_pos
apron7318833apron
arbor74818113arbor
arch98628443arch__
arched125717323arched
archer115016243archer
arches114822043arches
archfoe1544723archfoe
archil11611573archil
archly1437353archly
archons12311583archons
arco68331543a_rco
ardor64617863ardor
argol65317263argol
argon65520593argon
argot67728643argot
arhat8327093arhat
arioso64312403arioso
armor75118053armor
arrow83414883arrow
arroyo936963arroyo
arson55118833arson
arvo76023433a_rvo
arvos86015663arvos
ascot76522513ascot
ash67944603ash__
ashed97829773ashed
ashen87818673ashen
ashes86230613ashes
ashore9414613ashore
ashy107717353ash_y
askoi9507793askoi
askos95011773askos
aswoon947013aswoon
atom67824523a_tom
atop66124753a_top
audio62917103audio
author939763author
auto47432083a_uto
autos56523323autos
avion84218343avion
aviso85713963aviso
avo68936233a__vo
avos77227013a_vos
avow107816463a_vow
awol75620673a_wol
axiom143913593axiom
axion1211316913axion
axon115524303a_xon
azido155411543azido
azlon144312873azlon
azo128233393a__zo
azon135725053a_zon
baboo94319503baboo
bach116131393bach__
bached145519893bached
baches135426943baches
backhoe1847153backhoe
bacon95620593bac_on
bamboo12310013bamboo
barhop13319643barhop
bathos116215633bathos
bazoo163815673bazoo
behoof1458683behoof
bhoot104322093_bhoot
boho96923323boh_o
bohos105618253bohos
boo58163663__boo
boohoo1148833boohoo
broo65129823_broo
cabob114616803cabob
cacao95420003cacao
cacaos104616183cacaos
cache125122483cach_e
cached145419203cached
caches137926913caches
cachet134526413cachet
cachous14312563cachous
cahoots1238473cahoots
cahows14399123cahows
cajon144513903cajon
calo64936443_calo
calos74431903calos
cameo95924993cameo
camo85731753_camo
camos95927613camos
campo115219763campo
canoe75627253canoe
canon74725303canon
canso75019403canso
canto74931013canto
capo85829213_capo
capon95221873capon
capos94826073capos
carbo94923843carbo
cargo85322073cargo
carhop133610763carhop
carob95325223carob
carol75128613carol
carom95025563carom
cashoos12310793cashoos
cero66329453_cero
chad105525503_chad
chai95929903_chai
cham115532313_cham
chaos105622863_chaos
chap114928493_chap
char95132153_char
chat95546133_chat
chaw126224633_chaw
chay124924873_chay
chef125125623_chef
chemo12313633_chemo
chew126622133_chew
chez184519023_chez
chi86228653_ch_i
chia96026623_chia
chiao105618363_chiao
chic115925203_chic
chico124218253_chico
chid106626403_chid
chin96934743_chin
chino105823313_chino
chip116726423_chip
chiro105320343_chiro
chis95933313_chis
chit96937463_chit
chock164316613_chock
choir105313593_choir
choke145118023_choke
choky175711223_choky
chola104718033_chola
cholos114716853_cholos
chomp144815663_chomp
chooks155312793_chooks
choose115116143_choose
choosy14459103_choosy
chops125019873_chops
chord115917263_chord
chore105126763_chore
chose105925403_chose
chott103923923_chott
chows135618203_chows
chromo132811013_chromo
chub115516413_chub
chug105914113_chug
chum116318003_chum
ciao64924183_ciao
cion613330913_cion
clod76124613_clod
clog76123243_clog
clon66232483_clon
cloot76127053_cloot
clop86929893_clop
clot66542423_clot
cloy96623833_cloy
cob710258753_c_ob
coco87330603_coco
cod69660123_c_od
cog69552903_c_og
cohog117813043cohog
cohos105921853cohos
col59360353_c_ol
con510268023_c_on
coof96643273_coof
cook107236933_cook
cool66940493_cool
coon67248943_coon
coop87238653_coop
coos67456493_coos
coot67860383_coot
cop711162373_c_op
cor59960943_c_or
cos510270393_c_os
cot510483223_c_ot
cow89856713_c_ow
cox1210346783_c_ox
coy810557553_c_oy
coz149345363_c_oz
croc85723733_croc
crook115217573_crook
croon75522783_croon
crop87628633_crop
crow96428133_crow
cuckoo1486413cuckoo
dacha114812573dach_a
dachas124113253dachas
dacron94310693dacron
dahoon1039053dahoon
dhow116614003_dhow
each95530583each__
eche97520283ech_e
eched116919223eched
eches106322163eches
echoed125211153echoed
echoer114011103echoer
echoes114715523echoes
echoey14397853echoey
echoic1339043echoic
echt95722903ech_t
ephod1139123ephod
ephor10310013ephor
ethos85514193ethos
factor11911453factor
fathom1437473fathom
gaucho1256223gauch_o
gauchos1345893gauchos
gazoo153112873gazoo
goo47754773__goo
halloo95118973halloo
hao67251123__hao
ho510258273__h_o
hob87550923__hob
hobo97026083__hobo
hod76852463__hod
hoe67562723__hoe
hog78049063__hog
homo96126473__homo
hon67759383__hon
hood85132333__hood
hoof106036583__hoof
hook116133283__hook
hoop96129983__hoop
hoot75752093__hoot
hop87554593__hop
hos68364193__hos
hot67776053__hot
how97252433__how
hoy97447913__hoy
ich86227743ich__
ichors11310413ichors
ichs96214713ich_s
icon66922043ic_on
igloo6410493igloo
karoo92519583karoo
karroo10410013karroo
kazoo183311533kazoo
kerchoo1644973kerchoo
laches116528343laches
ladhood1246473ladhood
loo38359823__loo
macaco1247853macaco
mach116134473mach__
mache125925303mach_e
maches134827233maches
machs125722563mach_s
machzor2344263machzor
macon94519953mac_on
macro94718173mac_ro
macron103615673macron
macros104017013macros
mahoe10315573mahoe
manhood1338993manhood
mho86624623_mh_o
mhos95517773_mhos
moo58460513__moo
mucho125013443much_o
nachas114914193nachas
naches114622413naches
nohow1137293nohow
noo37154043__noo
ocher104516103ocher
ochone11311293ochone
ochre103411593ochre
ochry13346933ochry
oho66534383_oh_o
pacha126518063pach_a
pachas135017143pachas
pachuco1642903pachuco
pathos115516693pathos
phon95925383_phon
phono104917023_phono
phot95534353_phot
photo104417223_photo
poo57757113__poo
raccoon1176163raccoon
rachet115028973rachet
rachis114017653rachis
racon75422143rac_on
racoon83814473racoon
rancho114310853ranch_o
ranchos123911393ranchos
rho65924833_rh_o
rhos76319063_rhos
sachem134012223sachem
sachet114725773sachet
salchow1544323salchow
schav1338313schav
schizo20115993schizo
schmoe13328333schmoe
schmoos14347513schmoos
schmos13379153schmos
schnook1654483schnook
schnoz2035643schnoz
schools1249113schools
schorl1179803schorl
schrod1247883schrod
schul102510413schul
schwa13426843schwa
scion72214993scion
scoop95617163scoop
scoot75729143scoot
scop85925523sc_op
scot66242603sc_ot
scow96021423sc_ow
scrod85115063scrod
scroop10299773scroop
scudo85412213scudo
shmo95318093_shmo
shod86225053_shod
shoe75933433_shoe
shog86025133_shog
shook124920153_shook
shool84523143_shool
shoon84022003_shoon
shoos84226353_shoos
shoot84235893_shoot
shop95629833_shop
shot76150243_shot
show106229183_show
taboo73418093taboo
tach96132753tach__
tache106222373tach_e
taches114224173taches
tachs105820933tach_s
tachyon1544623tachyon
taco67031353tac__o
tacos77023553tac_os
tattoo6310973tattoo
techno1135953techno
thio77225413_thio
tho67433963_th_o
thoro86217873_thoro
thou76722213_thou
thro77726423_thro
too38965423__too
unhood1039233unhood
unhook1347523unhook
wacko145514383wac_ko
wackos155210993wackos
wahoos122310593wahoos
wazoo173011173wazoo
who95526773_wh_o
whoa106615203_whoa
whom127018173_whom
whoof144612693_whoof
whoop134211443_whoop
whop125520923_whop
whoso11509223_whoso
woo66949803__woo
yacht13417393yach_t
yachts1437023yachts
yahoos12209243yahoos
zoo126238913__zoo

Search took 5 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 Filter178691836670.1261418182.5
2DLD Change Limit836675134.20319906.5
3Display Results5135130.1403664.3
 (SQL Overall)1786915134.46939984.6
 
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.