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

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

47 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
rees4536419(None) 
bees65453381bees
brees75632551brees
cees65941591cees
dees56356631dees
drees65628521drees
fees76450601fees
frees86131391frees
gees55647881gees
grees65132471grees
jees115938541jees
lees45455881lees
pees65257371pees
prees75937171prees
rebs65733561rebs
recs65734181recs
redes65139121redes
reds56042861reds
ree37974071ree_
reed55549621reed
reeds65430901reeds
reef74938211reef
reefs85121661reefs
reek85232521reek
reeks94124031reeks
reel45240531reel
reels55333261reels
reest54938091reest
refs75732241refs
reges65628781reges
regs55436571regs
reis45343231reis
rems66237721rems
reps65937951reps
res35565041r_es
rets45352561rets
revs75027051revs
rexes124526951rexes
roes45954131roes
rues46044481rues
ryes75529351ryes
sees45361051sees
tees45353581tees
trees55835761trees
vees75439431vees
wees76249121wees
zees136331891zees

Search took 1 second 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 Filter178691139830.0762351197.4
2DLD Change Limit13983470.26652567.7
3Display Results47470.0162937.5
 (SQL Overall)178691470.358499136.9
 
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.