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

141 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
comte9612547(None) 
comae97128421comae
comate104124841comate
combe116223541combe
come87547701com_e
comet95946071comet
comtes106222811comtes
conte76633201conte
cote66648731co_te
boite74426322boite
bombe115519312bombe
came87648752cam_e
carte75940422carte
caste75932362caste
cate66254602c_ate
cete64934782c_ete
chute104316462chute
cite65640342c_ite
coat67558352coat_
coated94927042coated
coatee84327222coatee
coater84329572coater
coati75624642coati
coats75635002coats
coble94823172coble
code77347732co_de
coft97939682coft_
coke107038382co_ke
cole66956112co_le
colt67158242colt_
colter84625092colter
colts76633292colts
coma87134852com_a
comade114415322comade
comake144413422comake
comal95125132comal
comas95833002comas
comates114123642comates
comb106632112com_b
combed135516542combed
comber125118502comber
combes125321732combes
combo114519432combo
combs116122962combs
comer95832692comer
comes97246992comes
cometh134811682cometh
comets105823582comets
comfy153710212comfy
comic114721812comic
comity13312712comity
comix163513202comix
comma114514792comma
commie124215522commie
commute134310442commute
commy144712642commy
comose105016842comose
comp106731252com_p
comped135919872comped
compel124412892compel
compete134716552compete
compo115318572compo
compote135616462compote
comps115526052comps
compt116328222compt
compted143813522compted
compts125216652compts
compute134513662compute
cone67256962co_ne
conge85227592conge
contes84432912contes
conto76027172conto
cooee74531022cooee
coombe124110092coombe
coot67860382coot_
cooter85128612cooter
cootie84223092cootie
coots75636842coots
cope86847382co_pe
copse95623922copse
copter109822012copter
core67263112co_re
corse75036182corse
cortex15311472cortex
coset75748842coset
cosie74728262cosie
cost68057942cost_
costa75523732costa
costae85319682costae
costed95623112costed
coster84331292coster
costs77231142costs
cot510483222co_t_
coted85033852co_ted
cotes76347842co_tes
cots68054842co_ts
cotta75818572cotta
cottae84615702cottae
cotter84926672cotter
coude85022632coude
coupe96023482coupe
couter84930222couter
couth106122492couth
cove95837072co_ve
covet105638942covet
coxae146115182coxae
coyote11411782coyote
cozie163519132cozie
crate76537402crate
croute84617272croute
cute66440452c_ute
cymae126713012cymae
cyme119420372cym_e
dome77240732dom_e
dote55442882do_te
emote75421192emote
fomite113314072fomite
forte86131462forte
home98042442hom_e
homie104622532homie
lotte54923852lotte
mome85239352mom_e
monte75829772monte
moste75925082moste
mote67048082mo_te
motte75526972motte
nome66038422nom_e
note46239962no_te
pome85636692pom_e
rote46249022ro_te
rotte54625932rotte
route55132072route
smote75820282smote
some66040382som_e
somite84519372somite
tome67543192tom_e
torte55431702torte
tote46643672to_te
vicomte1445722vicomte
volte85321302volte
vote74728622vo_te

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538001411.78330173.9
3Display Results1411410.0304700.0
 (SQL Overall)1786911412.12684050.3
 
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.