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

58 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
lancelets114483(None) 
lancelet1049471lancelet_
cancelers13247862cancelers
flannelets1342452flannelets
laceless10239852la_celess
lancets93411162lanc__ets
lannerets9225482lannerets
mantelets1176812mantelets
aneles64626293_an_ele_s
anklets114310413_an_klets
annulets845813_annulets
bannerets11205463bannerets
bracelets1345963bracelets
branchlets1743803branchlets
canceled13279403cancele_d
canceler12238913cancele_r
cancellers1445363cancellers
cancels114113313cancel__s
capelets1268603ca_pelets
faceless13269173fa_celess
fanciless1444603fanciless
fenceless1444163fenceless
flannelet1245253flannelet_
gantlets9308903gan_tlets
kanteles1238123kantele_s
labelers10249413la_belers
lanceolate1253213lanceolate
lancers93616643lanc__ers
lances84824103lanc__e_s
lancet84223573lanc__et_
lanceted1137073lancete_d
lanciers10308543lanc_iers
landaulets1142273landaulets
landlers94312833lan_dlers
landless94011173lan_dless
langleys1245103lan_gleys
languets987243lan_guets
lanneret82512363lanneret_
larceners1135993larceners
latchets133410013latc_hets
lineless82711943lin_eless
manchets15269573manc_hets
maneless102812343man_eless
mantelet10613823mantelet_
mantlets104611203man_tlets
paneless102611763pan_eless
pantalets1147673pantalets
placeless1335613pla_celess
planchets16236743planc_hets
plantlets1145013plan_tlets
platelets1165763pla_telets
princelets1443463princelets
ranchless1444453ranchless
rondelets1045263rondelets
sarcenets1146953sarcenets
tercelets1144813tercelets
valvelets1542793valvelets
wavelets1436153wa_velets

Search took 9 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 Filter1786911486410.436409841.7
2DLD Change Limit148641587.56319653.7
3Display Results58580.0301933.3
 (SQL Overall)178691588.02922255.7
 
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.