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

55 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
readopting146551(None) 
preadopting1743991preadopting
readapting1445151readapting
adopting1237452__adopting
preadapting1743652preadapting
readorning1245722readorning
adapting1236643__adapting
eradiating1248733eradiating
headspring17133243headspring
radiating111112133r_adiating
ragouting1134893r_agouting
reaccepting1863893reaccepting
reacting113317893rea__cting
readdicting1643813readdicting
readding11411363read__ding
reading93327213read___ing
readjusting2042903readjusting
readmitting1544053readmitting
readopt10410843readopt___
readopted1344923readopt_ed
readopts1146493readopt__s
readying13410223read__ying
reallotting1243673reallotting
reanointing1244993reanointing
reaping103621213rea__p_ing
rearousing1156463rearousing
reasoning10310203reaso_ning
reassorting1245023reassorting
reavowing1634863reavo_wing
rebooting12139023re_booting
receipting1546753receipting
recoating121317463re_coating
recopying1737123re_copying
redacting13612303re_dacting
redating102620173re_d_ating
redipping1555593re_dipping
redocking17126783re_docking
redoing93516733re_do__ing
redonning11127643re_donning
reediting11310953reed_iting
refloating14198323refloating
refronting1437273refronting
reknotting1564233reknotting
repeopling1544233repeopling
replotting1357043replotting
reporting12513903re_porting
repotting12511123re_potting
reradiating1347263reradiating
rerouting10311873re_routing
reshooting1436223reshooting
resorting10614613re_sorting
respotting1347113respotting
retorting10613273re_torting
revolting1339633re_volting
revoting12312033re_vo_ting

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 Filter1786911406030.423422437.4
2DLD Change Limit140603557.07619870.4
3Display Results55550.0331666.7
 (SQL Overall)178691557.53223724.2
 
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.