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

113 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
lunette73748(None) 
lunettes836751lunettes
brunette1044722brunette
burette939852burette
cuneate9311722cuneate
curette939782curette
cuvette1235832cuvette
dinette8310012dinette
fumette1245522fumette
genette838862genette
layette1037132layette
lineate7815152lineate
lunate6316042lun_ate
lunet56835422lune_t_
lunets66914762lune_ts
musette938432musette
tonette7310372tonette
alunite7311633alun_ite
ariette7312373ariette
auntie64317703aun_tie
aureate72515283aureate
brunettes1144583brunettes
burettes1048943burettes
butte74924293bu__tte
casette9310393casette
culotte976893culotte
cuneated11310103cuneated
curetted1137173curetted
curettes1039313curettes
cuvettes1335323cuvettes
dinettes9310193dinettes
duetted937023du_etted
dunite7315013dun_ite
dunnite857333dunnite
fouette1038213fouette
fumettes1345773fumettes
funest94316863funest_
galette84212693galette
gazette17357363gazette
genettes938303genettes
gunite7414403gun_ite
kunzite2053503kunzite
lanate6421263lan_ate
languette1045113languette
latte55426303l__atte
laundrette1152073laundrette
laureate888023laureate
layettes1136263layettes
lenite6719983len_ite
lethe85717303l__ethe
letted74118543l__etted
letter63722583l__etter
licente91210893licente
lineage878983lineage
lineated9711063lineated
lisente71210703lisente
lorgnette1043113lorgnette
lotte54923853l__otte
lucence11147993lucence
lucent8313823lucent_
lucerne945753lucerne
lucite8313343lu_cite
luetic8310383lu_etic
lunated8310823lunated
lunatic938753lunatic
lune47140493lun___e
lunes55337773lune__s
lunge65323803lun__ge
lungee75119813lun_gee
luniest73516993luniest_
lunt46148843lun__t_
lunted74517523lun_ted
lunts55826903lun__ts
lunulae735613lunulae
lunulate838253lunulate
lunule638433lun_ule
lustre64011683lu_stre
lute46341013lu___te
luxate1338083lu_xate
mofette1296773mofette
mozette1886773mozette
musettes1037433musettes
navette1036983navette
nett46643233__nett_
netted74118713__netted
netter63722023__netter
nettle64514583__nettle
netts55320723__netts
netty85816763__netty
octette946423octette
palette93613983palette
pipette1137943pipette
proette9312363proette
punctate1246473punctate
quintette1843173quintette
rosette7310373rosette
roulette847093roulette
strette7310763strette
syrette1037183syrette
tonettes839203tonettes
uncute82912133_uncute
unease63816643_unease
uneaten7412543_uneaten
unfetter1136753_unfetter
unite54828383_un_ite
unletted9310313_unletted
unsettle866063_unsettle
unstate71916213_unstate
untie54425493_un_tie
unwetted1238123_unwetted
vedette1166003vedette
vidette1167543vidette
vignette1245043vignette

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 Filter1786911340270.216827273.1
2DLD Change Limit1340271136.69020033.9
3Display Results1131130.0303766.7
 (SQL Overall)1786911136.93625762.8
 
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.