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

87 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
sucre7501910(None) 
lucre76415521lucre
sucres84218891sucres
sure45447411su_re
acre67330772_acre
cure66149122cu_re
duce76933502duc_e
dure56341812du_re
euchre11137662euchre
luce65132572luc_e
lucres84513302lucres
lure45142462lu_re
mucro94513722mucro
mure65941332mu_re
murre74821072murre
nacre75715362nacre
outre53922202outre
puce85127882puc_e
pure65543332pu_re
quare143920542quare
quire144917132quire
ruche104216762ruche
sabre74821502sabre
sacra74516992sacra
sacred94917102sacred
sauce75121652sauc_e
saucer84314102saucer
scare75334462scare
score75526742score
scree720031712s_cree
screw109318542s_crew
scry96017762s_cry
scurf104719322scurf
scute75520942scute
secret8325062secret
secure8513532secure
sere46153472s_ere
share86437082share
shire84727132shire
shore85432652shore
sice65545592sic_e
sire46150412s_ire
snare54429982snare
snore55424952snore
socle7419572socle
sore47059532s_ore
source8410672source
spare75135562spare
spire75828692spire
spore75428592spore
square154513362square
squire155912462squire
stare54440262stare
stere55328542stere
store56333812store
suave83519872suave
suber74924502suber
such96424812suc_h
suck106131732suc_k
sucked134120492sucked
sucker124120662sucker
suckle124015962suckle
sucks114523072sucks
sucky144415502sucky
sucrase9310342sucrase
sucrose939302sucrose
sue35651462su__e
suede64419752suede
suer45334032suer_
suers55128482suers
suite54829562suite
supe65932762su_pe
super74924482super
supra73614252supra
sura45740292su_ra
surd56433812su_rd
surer54833102su_rer
surf76039312su_rf
surge65027692surge
surra55521342surra
surrey94414582surrey
sutra54217932sutra
suture6313202suture
sware85828212sware
swore84920822swore
syce95820282syc_e
sycee105018622sycee

Search took 4 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.610292936.1
2DLD Change Limit53800873.04617662.5
3Display Results87870.0165437.5
 (SQL Overall)178691873.67248663.1
 
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.