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

61 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
retaliated114843(None) 
retaliate9410631retaliate_
retaliates1049071retaliates
reradiated12177532reradiated
revalidated1654212revalidated
revaluated14306362revaluated
dealated103213603de_al_ated
defalcated1744183defalcated
defoliated1545833defoliated
desalinated1345773desalinated
devaluated15265493devaluated
emaciated1446933_emaciated
eradiated11178813_eradiated
evaluated13276653_evaluated
metalised12310463metali_sed
metalized21412183metali_zed
radiated102512593r__adiated
realigned1145333re_aligned
realised92214533re_ali_sed
realized182514223re_ali_zed
reanimated1347003re_animated
rebaited11410543reba_i_ted
recalibrated1753183recalibrated
reenlisted1144833reenlisted
reevaluated1552833reevaluated
reflated123514293re_fl_ated
refloated1347013re_floated
regelated1139723regel_ated
regulated11310463regul_ated
related83327573re__l_ated
relisted9312623re__listed
remediated1446553remediated
repainted1277863repa_inted
repatriated14114893repatriated
replated112817513re_pl_ated
replicated1548773re_plicated
repudiated1445443repudiated
reradiate10179033reradiate_
reradiates11177993reradiates
resaluted1046473resal_uted
reslated93517523re_sl_ated
retailed94113963reta_i_led
retailored1152953retailored
retained93016093reta_i_ned
retaliating1248873retaliating
retaliation11612323retaliation
retaliative1454983retaliative
retaliatory1453323retaliatory
retallied1046783retal_lied
retardate1047023retardate_
retardates1146423retardates
retargeted1243843retargeted
retasted92412113reta__sted
retinted94414363ret__inted
retreated10312613ret_reated
retwisted1344893ret_wisted
revalidate1454693revalidate_
revalidates1554353revalidates
revaluate12277103revaluate_
revaluates13246793revaluates
sealifted1344573se_alifted

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.1561145455.1
2DLD Change Limit140603617.65618365.1
3Display Results61610.0331848.5
 (SQL Overall)178691617.84522777.7
 
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.