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

54 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
reeded84022561reeded
beebee10313062beebee
bendee94121022bendee
breeder103210042breeder
deeded94615542deeded
feeder103513842feeder
freebee1238042freebee
heeded114215762heeded
heeder104216042heeder
needed84114442needed
needer73614952needer
needle73310612needle
peewee11311962peewee
reader73628292reader
recede95515532reced_e
receded112713042receded
recedes102816062recedes
redded94019552redded
redden83613622redden
redder83918142redder
reddle83815912reddle
rede55037672r_ed_e
reded74829122r_eded
redeem9311532redeem
redes65139132r_edes
redeye103811792redeye
redye94413472r_edye
reed55549622reed__
reedier83815302reedier
reedit7617222reedit
reedmen1038332reedmen
reeds65430902reed_s
reedy910020292reed_y
reefed103816582reefed
reefer93314362reefer
reeked113717642reeked
reeker103715592reeker
reeled74725532reeled
reeler63822572reeler
reeve84121322ree_ve
reeved104118712reeved
reeves94721492reeves
referee101615752referee
rended84524102rended
render74024142render
resee54336332r_esee
seeded84520462seeded
seeder74320772seeder
teepee8314362teepee
veepee11311482veepee
vendee105617262vendee
weeded113914872weeded
weeder103315512weeder
weewee12310082weewee

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551542.40634310.5
3Display Results54540.0163375.0
 (SQL Overall)178691542.78264231.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.