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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

69 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
lancelet104947(None) 
lancelets1144831lancelets
canceled13279402canceled
canceler12238912canceler
flannelet1245252flannelet
lancet84223572lanc__et
lanceted1137072lanceted
lanneret82512362lanneret
mantelet10613822mantelet
anele55628833_an_ele_
aneled74719283_an_eled
aneles64626293_an_eles
angeled93211513_angeled
anklet105618733_an_klet
annulet7311593_annulet
banneret102412473banneret
bracelet12310693bracelet
branchlet1647183branchlet
cancel105316683cancel__
cancelers13247863cancelers
cancelled1456743cancelled
canceller1366683canceller
cancels114113313cancel_s
cancered132411553cancered
capelet11517073ca_pelet
flanneled1343313flanneled
flannelets1342453flannelets
gantlet83616243gan_tlet
hanseled1237713hanseled
kantele1138253kantele_
kanteles1238123kanteles
labeled102510563la_beled
labeler92310183la_beler
laceless10239853la_celess
lance75126723lanc__e_
lanced93717723lanc__ed
lanceolate1253213lanceolate
lancer84319973lanc__er
lancers93616643lance_rs
lances84824103lanc__es
lancets93411163lance_ts
landaulet1045323landaulet
landler84113203lan_dler
landsleit1044203landsleit
lanely93914483lan_el_y
langley1147453lan_gley
languet8713693lan_guet
lankest112714113lanke_st
lannerets9225483lannerets
lapeled10258893la_peled
larcener1036493larcener
latchet123117913latc_het
laureled934543laureled
manchet143317783manc_het
mantelets1176813mantelets
mantlet93620993man_tlet
paneled10612573pan_eled
pantalet10415903pantalet
parceled1338343parceled
planchet152511963planc_het
plantlet10310013plan_tlet
platelet10510733pla_telet
princelet1346533princelet
rondelet9410353rondelet
sarcenet10413313sarcenet
spanceled1443693spanceled
tercelet1049883tercelet
valvelet1445343valvelet
wavelet13310943wa_velet

Search took 8 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.420425454.8
2DLD Change Limit146162697.34619896.8
3Display Results69690.0135307.7
 (SQL Overall)178691697.77922970.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.