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

140 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
rotte5462593(None) 
lotte54923851lotte
motte75526971motte
rotate63320341rotate
rote46249021ro_te
rotted74524431rotted
rotten64115431rotten
rotter64325461rotter
rottes64524831rottes
route55132071route
boite74426322boite
bott66548572bott_
bottle84916072bottle
botts75224862botts
butte74924292butte
comte96125472comte
conte76633202conte
cote66648732co_te
cotta75818572cotta
cottae84615702cottae
cotter84926672cotter
croute84617272croute
dote55442882do_te
dotted84717522dotted
dottel73610892dottel
dotter74419342dotter
dottle74212502dottle
dotty94516102dotty
forte86131462forte
fytte1138582fytte
garotte868702garotte
gotten73410112gotten
grotto7349812grotto
grotty10389832grotty
hotted104319932hotted
hotter94720072hotter
hottie92514362hottie
jotted143615172jotted
jotter134315632jotter
jotty155012602jotty
latte55426302latte
lotted74222402lotted
lotter64025602lotter
lottes65322752lottes
lotto55217572lotto
matte75626842matte
monte75829772monte
moste75925082moste
mote67048082mo_te
motet75641192motet
mott66648442mott_
mottes85523692mottes
mottle84116052mottle
motto76119512motto
motts76527002motts
notate63217862notate
note46239962no_te
orate55133302orate
otter54423972_otter
otto45220642_otto
potted94624012potted
potter83926982potter
pottle84416102pottle
potto75320942potto
potty105621002potty
proette9312362proette
rate45458762r_ate
rathe85821922rathe
ratite65022422ratite
ratted74923342ratted
ratten64217382ratten
ratter64326312ratter
rattle64717612rattle
ratty84819592ratty
rente54733782rente
rete44944132r_ete
retie55735302retie
retted74826312retted
rite45849452r_ite
ritter63822412ritter
robe65335642ro_be
roble75223022roble
rode55844302ro_de
roe36861072ro__e
rogue66417532rogue
role45851822ro_le
roose56127092roose
root45655922root_
rooted75424002rooted
rooter64926032rooter
rootle63214452rootle
roots55933672roots
rooty86423022rooty
rope65542912ro_pe
roque144812132roque
rose46148902ro_se
roset55945242roset
rosette7310372rosette
roster64329082roster
rot37282952ro_t_
rota45834342ro_ta
rotas54827722rotas
rotated82715292rotated
rotates72819772rotates
rotch105815932rotch
rotche114311982rotche
rotes56143902rotes
roti46332922ro_ti
rotis56327052rotis
rotl45029682ro_tl
rotls55620162rotls
roto45935052ro_to
rotor55519732rotor
rotos56027882rotos
rots46454092ro_ts
rotters74421392rotters
roue45941742ro_ue
rouge65423442rouge
rouse56634702rouse
rout46153282rout_
routed75624332routed
router65025842router
routes66129312routes
routh86423072routh
routs57133412routs
rove75136982ro_ve
rowth115713232rowth
rutted74518402rutted
rutty85617802rutty
sotted74121392sotted
torte55431702torte
tote46643672to_te
totted74319952totted
totter65021462totter
trotted83711282trotted
trotter73312252trotter
volte85321302volte
vote74728622vo_te
wotted104115712wotted
wrote84717482wro_te

Search took 2 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.1261418182.5
2DLD Change Limit538001401.67032215.6
3Display Results1401400.0334242.4
 (SQL Overall)1786911401.82997698.7
 
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.