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

86 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
resurrecting155312(None) 
resubjecting2451992resubjecting
resurrection1453352resurrection
resurrections1553462resurrections
rearresting1245963re_arresting
redirecting1545613re_directing
reerecting1339973re__erecting
resecting122816483res___ecting
reselecting1446023res_electing
respecting1549883res__pecting
restricting1449303res_tricting
resurfacing1742513resurfac_ing
resurrect1144883resurrect___
resurrected1452673resurrect_ed
resurrectional1661753resurrectional
resurrects1242823resurrect__s
resurveying1842593resurve_ying
correcting15199304__correcting
deselecting1544474des_electing
destructing1546114des_tructing
erecting112415064_e___recting
estreating11710364_es_treating
ferreting13127694fe__rre_ting
genuflecting1961254genuflecting
insurrection14104384insurrection
insurrections15104144insurrections
misdirecting1853244misdirecting
perfecting1847514pe__rfecting
preerecting1646144pre__erecting
preselecting1744294pres_electing
presurveying2151354presurve_ying
recarpeting1674364recarpe_ting
recollecting1764084recollecting
reconnecting1745354reconnecting
recreating131214584re__creating
recuperating1744994recuperating
recurring1237954recurr___ing
redefecting1844374re_defecting
reejecting2045814re__ejecting
reelecting1338784re__electing
refecting152413354re___fecting
reflecting1638824re__flecting
reforesting1546194re_foresting
refracting1638734re__fracting
regreeting1237344re__greeting
regretting1237784re__gretting
reinfecting1745154re_infecting
reinjecting2144454re_injecting
reinspecting1763204reinspecting
rejecting192211154re___jecting
relubricating1863094relubricating
relucting1239774relu___cting
remarketing1843714remarke_ting
remunerating1545424remunerating
reobjecting2343034re_objecting
reorienting1246354re_orienting
requesting2046314requ__esting
rerenting102617664re___renting
rescreening1444084res_creening
researching1743424resear_ching
reseating102421534res___eating
resegregating1652844resegregating
resenting102619294res___enting
reservicing1753424reservic_ing
resetting102816294res___etting
resmelting1337264res__melting
resorting10614614res_or__ting
respreading1545174res_preading
resprouting1445054res_prouting
restarting11310664restar__ting
restressing1266044res_tressing
restretching1852894restretching
resubmitting1752034resubmitting
resulting10311084resu___lting
resurging1138614resu_r__ging
resurrectionist1762834resurrectionist
resuspending1651714resuspending
retargeting1343934retarge_ting
retracting13311934re__tracting
retreating111414774re__treating
retroacting1447284re_troacting
subjecting2245554__subjecting
surfeiting1445024__surfeiting
suspecting1565704__suspecting
susurrating12114014susurr_ating
unsuspecting1751974unsuspecting

Search took 9 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 Filter1786911247900.406440125.6
2DLD Change Limit124790868.22015181.3
3Display Results86860.110781.8
 (SQL Overall)178691868.73620454.6
 
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.