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

102 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
layettes113626(None) 
layette1037131layette_
casettes1039652casettes
galettes93111152galettes
gayeties1236882gayeties
gazettes18296862gazettes
lattes65324202la__ttes
lunettes836752lunettes
navettes1136612navettes
palettes103112832palettes
abetted1058323_abetted
abetter958323_abetter
abetters1057173_abetters
acetates102013063_acetates
aretes64425353_are_tes
ariettes8411353ariettes
baguettes12115393baguettes
barbettes1348163barbettes
barrettes1149063barrettes
burettes1048953burettes
calottes10610083calottes
caseates10313713caseates
casette9310393casette_
cassettes1146703cassettes
cavettos1344973cavettos
cayennes1345013cayennes
curettes1039313curettes
cuvettes1335323cuvettes
dinettes9310193dinettes
facetted1445743facetted
fouettes1137883fouettes
fumettes1345773fumettes
fyttes1236933_fy_ttes
gaieties9310183gaieties
galette84212693galette_
gametes10312253game_tes
garottes978283garottes
gavottes1274183gavottes
gazette17357363gazette_
gazetted19234853gazetted
genettes938303genettes
jadeites1645823jadeites
labiates101011513labiates
lacerates112413773lacerates
lactates10311223lactates
laities7320343la_ities
lamented1138193lamented
lamenter1038863lamenter
lamenters1137683lamenters
laments94314853lament_s
languettes1144643languettes
larees65323113lare__es
latents75214313latent_s
laterites9715053laterites
latests73910313latest_s
latexes1438313late_xes
lathes95127493la__thes
latkes104715873la__tkes
latte55426303la__tte_
latten65018203la__tten
lattens75014673la__ttens
latter65027893la__tter
laureates987683laureates
laxities1539093laxities
layerages1345303layerages
layered11259413laye_red
layers93921183laye__rs
layouts1046483layout_s
lazarettes1953013lazarettes
lethes94818083l__ethes
letted74118543l__etted
letter63722583l__etter
letters73819853l__etters
lottes65322753l__ottes
lunette737483lunette_
lysates10317473l_ysates
lyttas985073l_y_ttas
maleates103316343maleates
maquettes2045913maquettes
mattes85624533ma__ttes
mofettes1386083mofettes
musettes1037433musettes
navette1036983navette_
octettes1045533octettes
palette93613983palette_
pallettes1148803pallettes
palmettes1346883palmettes
parkettes15137593parkettes
payees114812903paye__es
pipettes1237563pipettes
playdates1554903playdates
playmates1646603playmates
proettes10312763proettes
raclettes1147013raclettes
rosettes8310343rosettes
safeties1139163safeties
syrettes1136963syrettes
tonettes839203tonettes
vedettes1265943vedettes
videttes1266333videttes
yentes95517603__yentes
yetts86715133__yett_s

Search took 7 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621026.26623326.2
3Display Results1021020.0462217.4
 (SQL Overall)1786911026.71826598.8
 
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.