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

250 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
karroo1041001(None) 
karoo92519581ka_roo
karroos1139311karroos
arrow83414882_arrow
arroyo936962_arroyo
barrio8312572barrio
barroom1139372barroom
barrow114512762barrow
carrom10513402carrom
carrot8423122carrot
farrow12309972farrow
garron73113492garron
harrow122610772harrow
karoos102415802karoos
kazoo183311532ka_zoo
marron83717542marron
marrow112812602marrow
narrow9269142narrow
parrot8320662parrot
yarrow12287932yarrow
aarrgh10786303aarrgh
achoo10315083_achoo
aero45435343_aer_o
apron7318833_apron
arbor74818113_arbor
arco68331543_a_rco
ardor64617863_ardor
argol65317263_argol
argon65520593_argon
argot67728643_argot
arioso64312403_arioso
armor75118053_armor
arras55626133_arras
array86317143_array
arris56824683_arris
arroba898663_arroba
arrows92813483_arrows
arrowy12288273_arrowy
arroyos1036533_arroyos
arson55118833_arson
arvo76023433_a_rvo
arvos86015663_arvos
baboo94319503ba_boo
bamboo12310013bamboo
barhop13319643barhop
barlow112911423barlow
baron78131243ba_ron
barre75929543barr_e
barred95725793barred
barrel84517873barrel
barren85317613barren
barres84427543barres
barret84930483barret
barrios9310773barrios
barrooms1237893barrooms
barrows123411683barrows
baryon111211613baryon
bazoo163815673ba_zoo
borrow114310723borrow
broo65129823__broo
burgoo938933burgoo
burro75018493burr_o
burros85114993burros
burrow114610803burrow
carbo94923843ca_rbo
carbon104919043carbon
carbos105122263carbos
carboy134914183carboy
cardio9915673cardio
cardon94120853cardon
cardoon104813813cardoon
cargo85322073ca_rgo
cargos94619183cargos
carhop133610763carhop
carob95325223ca_rob
carol75128613ca_rol
carom95025563ca_rom
carpool1139223carpool
carr65434703carr__
carrel84718633carrel
carrion9312673carrion
carroch1437093carroch
carroms11512403carroms
carrots9714623carrots
carroty1248943carroty
carrs75730853carr_s
carry105823783carr_y
carryon1237033carryon
carton84522663carton
cartoon94114463cartoon
cartop104213563cartop
cashoo11312253cashoo
charro114212953charr_o
charros124312143charros
dacron94310693dacron
darkroom1543423darkroom
dayroom1345233dayroom
eardrop1065223eardrop
error53712233_error
faro76136923fa_r_o
faros85532023fa_ros
farrago1144923farrago
farrows13259783farrows
furrow12427743furrow
gadroon938173gadroon
garcon92912483garcon
garred85217403garred
garret74426553garret
garrons82713463garrons
garrote8510103garrote
gazoo153112873ga_zoo
hadron102913753hadron
hairdo1036433hairdo
halloo95118973halloo
harbor11410723harbor
harlot94422803harlot
harpoon1238313harpoon
harrows132611033harrows
harry115322953harr_y
horror988723horror
jargon1448823jargon
jargoon1545193jargoon
jarrah1636683jarrah
jarred144613253jarred
kabob134113923ka_bob
kakapo1143853kakapo
kangaroo1363473kangaroo
kaon87521023ka__on
kapok10448783ka_pok
karaoke1044903karaoke
karat96837593ka_rat
karate105320923karate
karats106420493karats
karma113415003ka_rma
karmas123013733karmas
karmic1438113karmic
karn86129413ka_r_n
karns96624143ka_rns
kaross101910013kaross
karst97228993ka_rst
karsts106012943karsts
kart86750803ka_r_t
karts97630113ka_rts
kation104315683kation
kauri93811843kaur_i
kauris103611523kauris
kaury12429763kaur_y
kayo116417553ka__yo
kayos127714703ka_yos
kazoos19259113kazoos
kerchoo1644973kerchoo
kerria10339913kerria
kerry124916093kerr_y
knarred12266003knarred
knarry1334613knarr_y
koodoo11107773koodoo
kouroi1036513kouroi
kouros1039183kouros
kroon94514483k_roon
ladron73413323ladron
lardon74415063lardon
lardoon83410373lardoon
largo65319783la_rgo
largos74815063largos
larrup835713larrup
macro94718173macr_o
macron103615673macron
macros104017013macros
madrono10288743madrono
marmot10318743marmot
maroon83118203maroon
marram10313883marram
marrano939423marrano
marred95421043marred
marrer83716673marrer
marrons93216973marrons
marrows122911813marrows
marrowy15236083marrowy
marry104821693marr_y
matron83918313matron
mirror848003mirror
morro73216953morr_o
morros83714673morros
morrow113510093morrow
narco76718243na_rco
narcos86714203narcos
narrows10258843narrows
natron64116023natron
paramo102614643paramo
pardon94618733pardon
pareo74632603pa_reo
pareos87023773pareos
pargo86723723pa_rgo
pargos95719043pargos
parlor8312673parlor
parol74826273pa_rol
parr65731153parr__
parral85517533parral
parred95024073parred
parrel84515983parrel
parrots9312743parrots
parroty1247863parroty
parrs75928673parr_s
parry105323753parr_y
parson83817903parson
parton84720993parton
partook1337313partook
parvo107719183pa_rvo
parvos116614753parvos
patrol83213023patrol
patron84018043patron
patroon92811973patroon
perron83216623perron
pyrrol1136273pyrrol
ramrod936833ramrod
safrol937283safrol
sargo65424413sa_rgo
sargos74318273sargos
sarod65325873sa_rod
saros55238063sa_ros
sartor6313873sartor
sorrow9339443sorrow
sparrow1234263sparrow
taboo73418093ta_boo
taproom1147963taproom
taproot9412673taproot
tardo65321103ta_rdo
taro46846913ta_r_o
taroc75721643ta_roc
tarok97921073ta_rok
taros55640823ta_ros
tarot55943933ta_rot
tarpon82812803tarpon
tarre55825633tarr_e
tarred74720283tarred
tarres64723043tarres
tarry85422513tarr_y
tattoo6310973tattoo
terror63811723terror
vagrom1235943vagrom
varoom11411413varoom
wahoo112413083wa_hoo
wardroom1445043wardroom
wareroom1346513wareroom
warred104019843warred
warren95012853warren
warrior1045363warrior
wazoo173011173wa_zoo
yahoo112911543ya_hoo
yarrows13277853yarrows

Search took 9 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 Limit1127162508.11013898.4
3Display Results2502500.1531634.0
 (SQL Overall)1786912508.40321265.1
 
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.