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

397 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
coombes13381066(None) 
combes125321731c_ombes
coombe124110091coombe_
coombs124210191coomb_s
bombes124916822_bombes
combe116223542c_ombe_
combed135516542c_ombed
comber125118502c_omber
combers134516612c_ombers
combos125316612c_ombos
combs116122962c_omb_s
comes97246992c_om_es
commies133718442commies
comtes106222812c_omtes
cooches143515832cooches
cooees85621892coo_ees
cookies133719272cookies
coolies93824962coolies
coomb115615702coomb__
cooties93725732cooties
crambes1339952crambes
roomies93017242roomies
adobes94411523ado_bes
anomies93316993anomies
atomies93918363atomies
biomes103815253biom_es
bombe115519313_bombe_
bombed134113873_bombed
bomber125014653_bomber
bombers134512593_bombers
bombs115818823_bomb_s
boobed114514873boo_bed
boobies113718203boobies
boobs96221993boo_b_s
boodies103721443boodies
boodles103416043boodles
boogies103719013boogies
bookies133819403bookies
boombox2073613boombox
boomboxes2243443boomboxes
boomed115318133boom_ed
boomer104618513boom_er
boomers114115913boomers
boomier113312183boomier
boomiest122711843boomiest
boomlet112412273boomlet
boomlets12246673boomlets
booms95427123boom__s
boonies93422483boonies
bootees94114473bootees
booties94124613booties
boozes174916523boo_zes
bromes104719763brom_es
cabombas1643813cabombas
camber124418473c_amber
cambers134017433c_ambers
cames97047313c_am_es
cammies134016473cammies
caribes113715643caribes
chamber164011053chamber
chambers173410613chambers
chimbs153910303chimb_s
chimes134922573chim_es
choices142010613choices
chokes154917383cho_kes
chomped17329773chomped
chomper163810073chomper
chompers17369573chompers
chomps155112223chom_ps
chooses125717413chooses
chores114828023cho_res
choses115825123cho_ses
chouses125117813chouses
chowses155611283chowses
chromes142914933chrom_es
chymes165912153chym_es
clamber133311733clamber
clambers144211283clambers
cleomes1138813cleom_es
climbed14336983climbed
climber13449133climber
climbers14318403climbers
climbs12498723climb_s
climes104720003clim_es
clobber13378163clobber
clobbers14397513clobbers
cloches144113713cloches
clomb115714703clomb__
clomped14398973clomped
clomps125212233clom_ps
clones84526563clo_nes
cloques18268563cloques
closes85425593clo_ses
clothes124513813clothes
cloves114918823clo_ves
clozes174915563clo_zes
clumber134011443clumber
clumbers143910393clumbers
coaches144018693coaches
coatees93816533coatees
coaxes154715633c_oaxes
cobber124116843c_obber
cobbers134114753c_obbers
cobbles133814823cobbles
cobbs115013993c_o_bbs
cobles104622883c_obles
cobs87043143c_o_b_s
cobwebs1631933cobwebs
cockles153414643cockles
cocomats1449403cocomats
cocottes1238303cocottes
coddles114213593coddles
codes86247293c_o_des
codices12512583codices
coelomes1239293coelom_es
coempts1335683coempts
coerces11311943coerces
coffees15329573coffees
coffles152610003coffles
coheres122917693coheres
cohoshes1635873cohoshes
cohunes1249713cohunes
coiffes1546803coiffes
coignes103912153coignes
cojones163512103cojones
cokes115537193c_o_kes
colbys13407153c_olbys
coles76055063c_o_les
colies84837053c_olies
collies94326583collies
colobus11389373colobus
colognes11310603colognes
colones96124433colones
colonies103620013colonies
colures9315133colures
comae97128423c_omae_
comakes154413643comakes
comas95833003c_om_as
comates114123633comates
comb106632113c_omb__
combat12316753c_ombat
combats13311683c_ombats
combines142814623c_ombines
combo114519433c_omb_o
combust1338353c_ombust
come87547703c_om_e_
comember1644163comember
comembers1744223comembers
comer95832693c_om_er
comers105328083c_omers
comet95946073c_om_et
comets105823583c_omets
comics124015563c_omics
commas124814573c_ommas
commie124215523commie_
commits133812373commits
commixes2177343commixes
commodes1539093commodes
commons13311043commons
commoves1736963commoves
communes143411233communes
commutes143011873commutes
comose105016843comose_
comous10816503c_omous
compas125817063c_ompas
comped135919873c_omped
compel124412893c_ompel
compels133210883c_ompels
compos124818803c_ompos
comps115526053c_om_ps
compts125216653c_ompts
comte96125473c_omte_
conches144019813conches
condoes104319203condoes
cones76457423c_o_nes
congees103517923congees
conges94928173c_onges
congoes103617303congoes
conies84338593c_onies
conines93827793conines
consommes1545633consommes
contes84432913c_ontes
cooed84534343coo__ed
cooee74531023coo__ee
cooeed95917863coo_eed
cooer74831013coo__er
cooers84324563coo_ers
cooey105828223coo__ey
cooeyed1346893cooeyed
cooeys114914483coo_eys
coofs105924713coo__fs
cooked135921363coo_ked
cooker124722453coo_ker
cookers134619463cookers
cookey155414333coo_key
cookeys16478503cookeys
cookie123716043cookie_
cookless14258633cookless
cooks115429143coo__ks
cooled95224583coo_led
cooler84824713coo_ler
coolers93522493coolers
coolest9318643coo_lest
coolie83821603coolie_
coolness1037743coolness
cools75632633coo__ls
coolths1236013coolths
coons76737283coo__ns
coonties10513793coonties
cooped114821603coo_ped
cooper104221123coo_per
coopers114019483coopers
coops96229643coo__ps
coopted123710763coopted
coopts105814583coo_pts
coos67456493coo___s
cooter85128613coo_ter
cooters94525713cooters
cootie84223073cootie_
coots75636843coo__ts
copes97747103c_o_pes
copies104130303c_opies
copses104922473c_opses
corbel103715973c_orbel
corbels113813593c_orbels
corbies113520113corbies
cores76361853c_o_res
cormel103815603corm_el
cormels113813373cormels
cormous11312353cormous
corms95626223corm__s
corodies11313693corodies
corpses113913803corpses
corries94026783corries
corses84433463c_orses
corvees124613793corvees
corves115122523c_orves
corymbed1842613corymbed
corymbs1633453corymb_s
coses76949493c_o_ses
coshes115022783c_oshes
cosies84932153c_osies
cosines94122673cosines
cosmids1237633cosmids
cosmos10311753cosm_os
cosmoses1239703cosmoses
cotes76347843c_o_tes
cotypes1437943cotypes
couches144020463couches
coulees9315503coulees
coulombs1443093coulomb_s
coupes105022523c_oupes
couples115317053couples
courses94218893courses
coves105539173c_o_ves
cowages13310933cowages
cowmen13810923cowm_en
cowpies143314283cowpies
cowries124218013cowries
coxcombs2342353coxcomb_s
coxes145430863c_o_xes
coyotes12410703coyotes
cozes166033243c_o_zes
cozies174521413c_ozies
cozzes164510893c_ozzes
crambe1239073crambe_
cramboes1436543cramboes
crambos1336783crambos
cremes104517993crem_es
crimes105521583crim_es
crones84729243cro_nes
cronies9622503cronies
crores86121163cro_res
crosses94220793crosses
croupes114613103croupes
croutes94815643croutes
crozes174417663cro_zes
crumbed14378473crumbed
crumber13339643crumber
crumbers14338223crumbers
crumbles14329683crumbles
crumbs12409233crumb_s
cubes95028163c__ubes
cumber124016703c_umber
cumbers134515393c_umbers
cymes1210118923c_ym_es
domes85735563_dom_es
doobies103915673doobies
doodies94218773doodies
doodles93614163doodles
doolees83711613doolees
doolies83920713doolies
doomed104113293doom_ed
doomier103610123doomier
doomiest112910453doomiest
dooms85321343doom__s
doozies173812723doozies
economies1348623economies
flambes14419503flambes
foodies113416753foodies
footies103721543footies
footles103715713footles
foozles19329543foozles
formes114623713form_es
gambes116318313_gambes
globes94314543glo_bes
gnomes93812973gnom_es
gombos114311093_gombos
goober93911743goo_ber
goobers10219623goo_bers
goodbyes15333503goodbyes
goodbys14354173goodbys
goodies93516993goodies
goombah1543113goombah
goombahs1642523goombahs
goombay1543553goombay
goombays1642823goombays
goonies83618333goonies
gooses75723053goo_ses
hombres14369873_hombres
homes106938813_hom_es
homies114524723_homies
hooches153812523hooches
hoodies113419833hoodies
hookies144017443hookies
hoopoes121212483hoopoes
hooves124815483hoo_ves
jambes175914053_jambes
kombus1435523_kombus
lobes75331003_lo_bes
loobies93814103loobies
looies65025833loo_ies
loomed94616763loom_ed
looms75124643loom__s
loonies73919543loonies
looses67328243loo_ses
momes95134473_mom_es
mommies103912273mommies
mooches143714453mooches
nombles113212343_nombles
nomes74933123_nom_es
noodges9317703noodges
noodles83513193noodles
noogies82814583noogies
nookies113414963nookies
nooses65623643noo_ses
obes66036833__o_bes
omber95316443__omber
ombers104214403__ombers
ombres103911143__ombres
oodles73517183_oodles
oomphs1344723_oomphs
oozes145418713_oo_zes
phoebes1435813phoebes
pomes94833933_pom_es
pommies133712843pommies
pooches143214163pooches
poodles103013513poodles
pooves113914713poo_ves
probes104119453pro_bes
rhombs13336493rhomb_s
rhombus14243893rhombus
robes75133303_ro_bes
roofies103014413roofies
rookies113917103rookies
roomed95218543room_ed
roomer84718633room_er
roomers95416413roomers
roomie83013873roomie_
roomier93812243roomier
roomiest102611993roomiest
rooms75324683room__s
rooses65526233roo_ses
rootles73215633rootles
scooches15188413scooches
sodomies11128553sodomies
somber103713993_somber
soothes103917103soothes
tombed113812133_tombed
tombs97818733_tomb_s
tomes76037383_tom_es
tommies113812983tommies
toonies73719883toonies
tootles72915603tootles
tootses72910773tootses
trompes114111623trompes
wombed14419233_wombed
wombs125813343_womb_s
woodies113517153woodies
woolies104117363woolies
woopses1237883woopses
wooshes13169883wooshes
yohimbes1841193yohimbes
zombies2037993_zombies
zombis1936283_zombis
zoomed183610363zoom_ed
zooms164415523zoom__s

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.1561145455.1
2DLD Change Limit1340273977.36018210.2
3Display Results3973970.1402835.7
 (SQL Overall)1786913977.65623340.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.