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

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
redelivered165184(None) 
delivered1445032__delivered
redeliver1344362redeliver__
redeliveries1652222redeliveries
redelivers1443552redeliver_s
redelivery1742282redeliver_y
undelivered1652642undelivered
deliverer1344503__deliverer
outdelivered176943outdelivered
predelivery2051893predeliver_y
redelivering1752413redelivering
resilvered1442993resil_vered
bedriveled1761714bed_riveled
beshivered1942184be_shivered
deliver113312244__deliver__
deliverers1443664__deliverers
deliveries1446014__deliveries
delivers123310754__deliver_s
delivery15286554__deliver_y
desilvered1542724__desilvered
enlivened1342994_e_nlivened
livered113111634____livered
realtered1037894re_al_tered
received1437984rece_iv__ed
receiver1337414rece_iver__
receivers1436364rece_iver_s
recovered15166734r__ecovered
redecided1455124redeci__ded
rededicated16144814rededicated
redeemed1235594rede___emed
redefied1368224redefi___ed
redefined1445594redefi__ned
redenied10511284redeni___ed
redesigned1343374redesi_gned
rediscovered1951904rediscovered
redivided1544254red__ivided
redivorced1742324red__ivorced
redlined103811234red_li__ned
redliner93510474red_liner__
redliners10267854red_liner_s
reelevated1445154re_elevated
reentered1038574re_e_ntered
refiltered1443774refil_tered
reflowered1742984re_flowered
relettered1144334rele_ttered
relieved12438514r__eli_eved
relived115114684r__eliv__ed
remembered1743354reme_mbered
reregistered1451924reregistered
rereviewed1741994rerevi_ewed
resoldered1243964resol_dered
retempered1543434rete_mpered
revered112819334r__e__vered
slivered12218104___slivered

Search took 10 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 Filter1786911488190.406440125.6
2DLD Change Limit148819548.89316734.4
3Display Results54540.0301800.0
 (SQL Overall)178691549.32919154.4
 
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.