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

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

70 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
reregistrations1672821reregistrations_
reregistration1583132reregistration__
preregistration1861753preregistration__
registrations1446893__registrations_
registration1347534__registration__
defenestrations1993305defenestrations_
fenestrations1695405fene__strations_
misregistration1871445misregistration__
remonstrations16116485re_monstrations_
renegotiations15113375reneg_otiations_
reregulations1455715rereg__ulations_
revegetations17114715reveg_et_ations_
administrations18162406administrations_
arbitrations1445766_ar_bi_trations_
cerebrations1646966cere___brations_
crepitations1647476_crepi_t_ations_
decrepitations1984346decrepi_t_ations_
defenestration18173546defenestration__
degustations1444836__degust_ations_
delegitimations19182446delegitimations_
demonstrations1795676de_monstrations_
deregulations1545206dereg__ulations_
deteriorations15164696deteri_orations_
detestations1347586dete__st_ations_
fenestration1596076fene__stration__
forestations1546326fore__st_ations_
frustrations1544536_fr__ustrations_
legislations1343756__legis_lations_
ministrations1555446__ministrations_
necessitations16122796necessit_ations_
orchestrations19113306_orchestrations_
penetrations1448856pene___trations_
peregrinations17114686pereg_rinations_
perpetrations1746376per__petrations_
perspirations1786176perspi__rations_
prefigurations2053026_prefigurations_
premeditations1955016premedi_t_ations_
prostrations1449766_pr__ostrations_
recalibrations1853696recali_brations_
recitations13314206__reci_t_ations_
redecorations1645086rede__corations_
rededications1746126rededi__cations_
reexportations2352846re_exportations_
reforestations1754466reforest_ations_
refrigerations1863776re_frigerations_
regenerations1447146__regenerations_
regurgitations16133146regurgi_t_ations_
reinfestations1793886reinfest_ations_
reinvigorations19152416reinvigorations_
reiterations12410876__re_iterations_
relegations1248976releg____ations_
remediations1548276remedi___ations_
remigrations15227796__remi_grations_
remonstration15117126re_monstration__
renegotiation14113666reneg_otiation__
reorchestration2072836reorchestration__
representations17153896represent_ations_
repristinations17193926re_pristinations_
reradiations1349496reradi___ations_
reregistering1592566reregist_eri_n_g
reregulation1346416rereg__ulation__
resegregations1653696reseg_regations_
respirations14410306re_spi__rations_
restations10315846__re__st_ations_
restorations12410956__re__storations_
revegetation16105306reveg_et_ation__
reverberations19113586reve_rberations_
sequestrations23182996se_questrations_
tergiversations1971386ter_giversations_
verbigerations2052476ver_bigerations_

Search took 6 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 Filter178691658740.326548131.9
2DLD Change Limit65874704.98613211.8
3Display Results70700.0631111.1
 (SQL Overall)178691705.37533244.8
 
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.