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

95 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
resurrected145267(None) 
resubjected2351492resubjected
resurrect1144882resurrect__
resurrects1242822resurrect_s
rearrested1145123re_arrested
redirected1444773re_directed
reerected1238613re__erected
resected112514743res___ected
reselected1345633res_elected
respected1438493res__pected
restricted1348303res_tricted
resurfaced1642463resurfac_ed
resurrecting1553123resurrecting
resurrection1453353resurrection
resurveyed1742053resurve_yed
corrected1438114__corrected
deselected1444084des_elected
destructed1445414des_tructed
erected103213994_e___rected
estreated1039554_es_treated
ferreted1236334fe__rre_ted
genuflected1851144genuflected
misdirected1752464misdirected
perfected1736644pe__rfected
preerected1545574pre__erected
preselected1643964pres_elected
presurveyed2061624presurve_yed
recarpeted1543704recarpe_ted
recollected1643854recollected
reconnected1665104reconnected
recreated12412534re__created
recuperated1645174recuperated
recurred1137094recurr___ed
recurrence1445314recurrence_
recurrences1544864recurrences
recurrent1146714recurrent__
recurrently1652754recurrently
redefected1743854re_defected
reejected1955094re__ejected
reelected1238314re__elected
refected142311664re___fected
reflected1547984re__flected
reforested1445384re_forested
refracted1557394re__fracted
regreeted1136174re__greeted
regretted1137234re__gretted
reinfected1645254re_infected
reinjected2044444re_injected
reinspected1642984reinspected
rejected182710114re___jected
relubricated1752854relubricated
relucted1138654relu___cted
remarketed1753584remarke_ted
remunerated1475354remunerated
reobjected2242254re_objected
reoriented1145344re_oriented
requested1935894requ__ested
rerented92516164re___rented
rescreened1344124res_creened
researched1643434resear_ched
reseated93220264res___eated
resegregated1552804resegregated
resented92716964res___ented
reserviced1643754reservic_ed
resmelted1236034res__melted
resorted9313494res_or__ted
respecter1347444res__pecter
resprouted1344224res_prouted
restarted10410054restar__ted
restressed1146644res_tressed
restretched1753214restretched
resubject2042314resubject__
resubjects2151594resubject_s
resubmitted1652014resubmitted
resulted939714resu___lted
resurface1443274resurfac_e_
resurfacer1551974resurfac_er
resurfaces1543014resurfac_es
resurged1038624resu_r__ged
resurgence1345494resurgence_
resurgences1445004resurgences
resurgent1047954resurgent__
resurrections1553464resurrections
resuspended1551584resuspended
retargeted1243844retarge_ted
retracted12410954re__tracted
retreated10312624re__treated
retroacted1366134re_troacted
subjected2144774__subjected
surfeited1344594__surfeited
suspected1444384__suspected
susurrated1143114susurr_ated
turreted935374__turre_ted
uncorrected1653954uncorrected
unsuspected1652034unsuspected

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.420425454.8
2DLD Change Limit148819958.62617252.4
3Display Results95950.0462065.2
 (SQL Overall)178691959.09219653.7
 
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.