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

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

61 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
lucre7641552(None) 
luce65132571luc_e
lucres84513301lucres
lure45142461lu_re
sucre75019101sucre
acre67330772_acre
cure66149122cu_re
duce76933502duc_e
dure56341812du_re
euchre11137662euchre
lace66848472lac_e
lacer75833752lacer
lice66045062lic_e
lire47845292l_ire
litre55421462litre
livre85613252livre
lore45850352l_ore
louche115212662louche
louvre9425682louvre
lube64731562lu_be
lucarne944262lucarne
lucern846102lucern
lucerne945752lucerne
luces75528432luces
lucid84314572lucid
lucite8313342lucite
luck105329822luc_k
lucked135118022lucked
luckie123611412luckie
lucks115723562lucks
lucky145515012lucky
lude55331642lu_de
luge55531642lu_ge
luger65322082luger
lune47140492lu_ne
lunge65323802lunge
lurch104814632lurch
lured65427492lu_red
lurer54625312lu_rer
lures56138532lu_res
lurex124816732lu_rex
lurk86624162lu_rk
lustre64011682lustre
lute46341012lu_te
luxe115222692lu_xe
lycee104716742lycee
lycra10317972lycra
lyre75623792l_yre
mucro94513722mucro
mure65941332mu_re
murre74821072murre
nacre75715362nacre
outre53922202outre
puce85127882puc_e
pure65543332pu_re
quare143920542quare
quire144917132quire
ruche104216762ruche
sucres84218892sucres
sure45447412su_re
ulcer7310752ulcer

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.310576422.6
2DLD Change Limit53800611.39338621.7
3Display Results61610.0134692.3
 (SQL Overall)178691611.716104132.3
 
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.