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 “comtes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

144 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
comtes10622281(None) 
comates114123641comates
combes125321731combes
comes97246991com_es
comets105823581comets
comte96125471comte_
contes84432911contes
cotes76347841co_tes
boites84322702boites
bombes124916822bombes
cames97047312cam_es
cartes86239472cartes
castes85631862castes
cates75951892c_ates
certes84623082certes
cetes75731102c_etes
chutes114615772chutes
cites74435592c_ites
coated94927042coated
coatee84327222coatee
coatees93816552coatees
coater84329572coater
coaters93525792coaters
coatis85122602coatis
coats75635002coat_s
coaxes154715632coaxes
cobles104622882cobles
codes86247292co_des
coitus8511892coitus
cokes115537192co_kes
coles76055062co_les
colies84837052colies
colter84625092colter
colters93522442colters
colts76633292colt_s
comae97128422comae_
comakes154413642comakes
comas95833002com_as
comate104124842comate_
combe116223542combe_
combed135516542combed
comber125118502comber
combers134516622combers
combos125316612combos
combs116122962com_bs
come87547702com_e_
comer95832692com_er
comers105328082comers
comet95946072com_et
cometh134811682cometh
comics124015562comics
comities12317792comities
commas124814572commas
commies133718452commies
commutes143011892commutes
comose105016852comose
comous10816512comous
compas125817062compas
comped135919872comped
compel124412892compel
compels133210892compels
competes144117242competes
compos124818802compos
compotes144716512compotes
comps115526052com_ps
compted143813522compted
compts125216652compts
computes143914552computes
cones76457422co_nes
conges94928172conges
conies84338592conies
conte76633202conte_
contest93523232contest
contos84923232contos
cooees85621892cooees
coombes133810662coombes
cooter85128612cooter
cooters94525722cooters
cooties93725732cooties
coots75636842coot_s
copes97747102co_pes
copies104130302copies
copses104922472copses
copter109822012copter
copters113621282copters
cores76361852co_res
corses84433462corses
cortex15311472cortex
corves115122522corves
coses76949492co_ses
cosets85824402cosets
coshes115022782coshes
cosies84932152cosies
costed95623112costed
coster84331292coster
costers94128332costers
costs77231142cost_s
cote66648732co_te_
coted85033852co_ted
cots68054842co_t_s
cottas84615572cottas
cotter84926672cotter
cotters94323442cotters
coupes105022522coupes
couter84930222couter
couters93827302couters
couths115715412couths
coves105539172co_ves
covets114819642covets
coxes145430862co_xes
coyotes12410702coyotes
cozes166033242co_zes
cozies174521412cozies
cozzes164510892cozzes
crates85736062crates
croutes94815652croutes
cutes79438322c_utes
cymes1210118922cym_es
domes85735562dom_es
dotes65836692do_tes
emotes84620282emotes
fomites123613202fomites
fortes95327182fortes
homes106938822hom_es
homies114524732homies
lottes65322752lottes
momes95134472mom_es
montes84226932montes
motes75944002mo_tes
mottes85523692mottes
nomes74933122nom_es
notes55034582no_tes
pomes94833932pom_es
pontes83627852pontes
rotes56143902ro_tes
rottes64524832rottes
routes66129312routes
somites94219122somites
tomes76037382tom_es
tortes64826052tortes
totes55139682to_tes
vicomtes1545592vicomtes
voltes94915582voltes
votes84627082vo_tes

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511442.61031628.7
3Display Results1441440.0334363.6
 (SQL Overall)1786911442.98659842.9
 
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.