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

242 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
karroos113931(None) 
karoos102415801ka_roos
karroo10410011karroo_
arrows92813482_arrows
arroyos1036532_arroyos
barrios9310772barrios
barroom1139372barroom
barrooms1237892barrooms
barrows123411682barrows
carroms11512402carroms
carrots9714622carrots
farrows13259782farrows
garrons82713462garrons
harrows132611032harrows
karoo92519582ka_roo_
kaross101910012ka_ross
kazoos19259112ka_zoos
marrons93216972marrons
marrows122911822marrows
narrows10258842narrows
parrots9312742parrots
yarrows13277852yarrows
across8312643_across
aprons8316993_aprons
apropos1138843_apropos
arbors84717883_arbors
ardors74416873_ardors
argols74514613_argols
argons75018203_argons
argots74116033_argots
arioso64312403_arioso
ariosos7409853_ariosos
armors85017813_armors
arras55626133_arr_as
arrays95311683_arrays
arris56824683_arr_is
arroba898663_arroba
arrobas969213_arrobas
arrow83414883_arr_ow
arrowy12288273_arrowy
arroyo936963_arroyo
arsons63917213_arsons
arvos86015663_a_rvos
aurous64119263_aurous
baboos103517013ba_boos
bamboos1348753bamboos
barhops14288113barhops
barlows12259973barlows
barons85025383ba_rons
barrels94514363barrels
barrens94414323barrens
barres84427543barr_es
barrets94917103barrets
barrio8312573barrio_
barrow114512763barr_ow
baryons121010473baryons
bazoos173212623ba_zoos
borrows12349253borrows
broos75126413__broos
burgoos1037123burgoos
burros85114993burr_os
burrows12399093burrows
carbons115418943carbons
carbos105122263ca_rbos
carboys144711783carboys
cardons104519943cardons
cardoon104813813cardoon
cardoons113411943cardoons
cargoes104415223cargoes
cargos94619183ca_rgos
carhops14329703carhops
carious93320283carious
carobs104818103ca_robs
carols85124983ca_rols
caroms105619573ca_roms
carpool1139223carpool
carpools1237883carpools
carrels95117303carrels
carries94328013carries
carrion9312673carrion
carrions10312453carrions
carroch1437093carroch
carrom10513403carr_om
carrot8423123carr_ot
carroty1248943carroty
carrs75730853carr__s
carryon1237033carryon
carryons1337103carryons
cartons94122473cartons
cartoon94114463cartoon
cartoons104012803cartoons
cashoos12310793cashoos
charros124312143charr_os
cirrous93111063cirrous
dacrons103211033dacrons
darkroom1543423darkroom
darkrooms1642913darkrooms
dayroom1345233dayroom
dayrooms1444343dayrooms
eardrops1165303eardrops
errors63311313_errors
faros85532023fa_r_os
farrow12309973farr_ow
ferrous1049803ferrous
furrows13327793furrows
gadroon938173gadroon
gadroons1037013gadroons
garcons102411643garcons
garrets84413623garrets
garron73113493garr_on
garrote8510103garrote
garrotes969363garrotes
gazoos163010223ga_zoos
hadrons113314303hadrons
hairdos1136823hairdos
halloos103716743halloos
harbors12412413harbors
harlots103413293harlots
harpoon1238313harpoon
harpoons1337483harpoons
harries103525493harries
harrow122610773harr_ow
horrors1078693horrors
jargons1558203jargons
jargoon1545193jargoon
jargoons1644663jargoons
jarrahs1735453jarrahs
kabobs14439303ka_bobs
kakapos1243673kakapos
kangaroos1473113kangaroos
kaons95014853ka__ons
kapoks11347263ka_poks
karaoke1044903karaoke
karaokes1145013karaokes
karates115617473karates
karats106420493ka_rats
karmas123013733ka_rmas
karns96624143ka_r_ns
karsts106012943ka_rsts
karts97630113ka_r_ts
kations114013663kations
kauries113613193kauries
kauris103611533kaur_is
kayoes134710823ka_yoes
kayos127714703ka__yos
kazoo183311533ka_zoo_
kerrias11289513kerrias
kerries113317913kerries
koodoos12116393koodoos
kouros1039183kour_os
kroon94514483k__roon
kroons103711243k_roons
ladrons83813193ladrons
lardons83914493lardons
lardoon83410373lardoon
lardoons9398483lardoons
largos74815063la_rgos
larrups934733larrups
macrons113514893macrons
macros104017013macr_os
madronos11337543madronos
marmots11311513marmots
maroon83118203ma_roon
maroons92615553maroons
marrams11310123marrams
marranos1038423marranos
marrers93414313marrers
marries93825283marries
marron83717543marr_on
marrow112812603marr_ow
marrowy15236083marrowy
matrons93517633matrons
mirrors938623mirrors
morros83714673morr_os
morrows12318723morrows
narcos86714203na_rcos
narrow9269143narr_ow
natrons73215663natrons
parados103816053parados
paramos113213513paramos
pardons103817623pardons
pareos87023773pa_reos
pargos95719043pa_rgos
parlors9312913parlors
parlous9414293parlous
parodos103011753parodos
parols84722613pa_rols
parous84024163pa_rous
parrals94414573parrals
parrels94713493parrels
parries93925843parries
parrot8320663parr_ot
parroty1247863parroty
parrs75928673parr__s
parsons93516873parsons
partons94620513partons
partook1337313partook
parvos116614753pa_rvos
patrols93513513patrols
patrons93818103patrons
patroon92811973patroon
patroons102710603patroons
perrons93115483perrons
pyrrols1235403pyrrols
ramrods1036583ramrods
safrols1036863safrols
sarcous9312933sarcous
sargos74318273sa_rgos
sarods74918573sa_rods
saros55238063sa_r_os
sartors7314973sartors
sorrows10278403sorrows
sparrows1344803sparrows
taboos83815433ta_boos
taproom1147963taproom
taprooms1246663taprooms
taproot9412673taproot
taproots1047253taproots
tarboosh1343143tarboosh
tarocs84615663ta_rocs
taroks106115283ta_roks
taros55640823ta_r_os
tarots66422993ta_rots
tarpons92612213tarpons
tarres64723043tarr_es
tarries73324263tarries
tattoos738643tattoos
terrors73112213terrors
various103113103various
varoom11411413va_room
varooms1248883varooms
wahoos122310593wa_hoos
wardroom1445043wardroom
wardrooms1544183wardrooms
wareroom1346523wareroom
warerooms1445823warerooms
warrens103810893warrens
warrior1045363warrior
warriors1135363warriors
wazoos18288553wa_zoos
yahoos12209243ya_hoos
yarrow12287933yarr_ow

Search took 8 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 Filter1786911340270.420425454.8
2DLD Change Limit1340272426.79619721.5
3Display Results2422420.0932602.2
 (SQL Overall)1786912427.30924448.1
 
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.