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

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

89 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
redesign104507(None) 
redesigns1144071redesigns
codesign1274512codesign
design8408932__design
reassign955422reassign
redesigned1343372redesigned
resign74212582r__esign
bedesman1345083bedesman
bedesmen1355713bedesmen
bedewing1537143bedewing
codesigns1353673codesigns
deign74312803__de_ign
designs9328313__designs
ensign737523_e_nsign
etesian757853_etesian
fedexing2034493fedexing
outdesign1142513outdesign
overdesign1543823overdesign
preassign1244573preassign
realign838763re_align
reassigns1074353reassigns
rebegin1036213rebegi_n
receding122713763receding
recension1148863recension
recessing12611013recessing
recession1149103recession
recision10310273recision
reconsign1245253reconsign
recusing112512883recusing
redating102620173redating
reddening1237433reddening
redding103218513red_ding
reddling112911813reddling
redecide12127183redecide
redeeming1337363redeeming
redefied1368223redefied
redefies12710163redefies
redefine1238973redefine
redefying1736093redefying
redenied10511283redenied
redenies9615713redenies
redenying1437783redenying
redes65139133redes___
redescend1395003redescend
redesigning1443653redesigning
redfin10310223red_fi_n
reding83825563red__ing
redoing93516733red_oing
redressing1247823redressing
redrying13209023redrying
redskin1286023red_skin
reducing12310203reducing
redwing122811983red_wing
redyeing1336173redyeing
reeding94124133re_eding
reedling102414273reedling
reefing114016863re_efing
reeking123318643re_eking
reeling83126863re_eling
reesting93118273re_esting
reeving113717663re_eving
refusing122310873refusing
reign65015193r__e_ign
rekeying1637563rekeying
releasing10411013releasing
remising112516453remising
rendering112213183rendering
reneging102111533reneging
renesting102514703renesting
renewing121910713renewing
reposing111213803reposing
rerising93017783rerising
reseeing92412623reseeing
resewing122712263resewing
resigns83910963r__esigns
resin54131053r__esi_n
retesting102614603retesting
reusing82516783re_using
reveling123117083reveling
revering122918073revering
reversing132611483reversing
reversion1248093reversion
revesting132814123revesting
revising122714403revising
revision1138723revision
reweigh1464773rewe_igh
rodeoing1037263rodeoing
undersign1177113undersign
wedeling1338773wedeling

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit146162897.26620115.9
3Display Results89890.0461934.8
 (SQL Overall)178691897.73223110.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.