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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

131 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
reiterative144753(None) 
iterative12410712__iterative
reintegrative17103252reintegrative
reiterate9412932reiterat__e
reiterating12410492reiterating
reiteration11412162reiteration
reiteratively1953792reiteratively
restorative1446942restorative
alliterative1553873alliterative
arbitrative1654263arbit_rative
deliberative1854053deliberative
desiderative1753683desiderative
federative1746163fe_derative
generative1458563ge_nerative
obliterative1753053obliterative
penetrative1646113penetrative
preoperative1955753preoperative
recitative1548183recit__ative
recreative1549023recre_ative
recuperative1954183recuperative
redintegrative1962183redintegrative
regenerative1655303regenerative
reiterated11410153reiterat_ed
reiterates10412003reiterat_es
reiterations12410873reiterations
remunerative1754763remunerative
reparative1548173re_parative
restoratives1554163restoratives
retentive1249853re_te_ntive
revertive1548853re_ver_tive
agitative1346874agit__ative
aliterate91611344aliterat__e
alternative1454684_alternative
cooperative1847054cooperative
declarative1754324declarative
decorative1648924de_corative
degenerative1754964degenerative
delineative1554664deline_ative
denigrative1655484denigrative
detective1548104de_te_ctive
detersive1346344de_ter_sive
detonative1447134de_tonative
detractive1647374de_t_ractive
deuterate1049514deuterat__e
deuterating1347274deuterating
deuteration1249104deuteration
deverbative2053624de_verbative
enumerative1654754enumerative
estimative1546484_estimative
execrative2246044_execrative
exertive1839084_e_xer_tive
exonerative2155394exonerative
extortive1945144_extor_tive
extractive2246604_ext_ractive
figurative1744114_figurative
gestative1347304gest__ative
ideative1238574__ide_ative
imitative1446334imit__ative
imperative1748564_imperative
initiative1346904init_iative
inoperative1646744inoperative
integrative1547124_integrative
interactive1659634_interactive
irritative1345204irrit__ative
iterate71119114__iterat__e
iterating10314254__iterating
iteration9515034__iteration
iteratively1745914__iteratively
lacerative1556284_lacerative
literalize1948744_literalize
literate81216894_literat__e
literati81210804_literati__
literatim11127184_literati_m
literation10511414_literation
literature1094194_literature
meditative1646284medit__ative
meliorative1655154meliorative
mitigative1644094_mitigative
operative141110554__operative
pejorative2245694pe_jorative
permeative1748524perme_ative
prefigurative2262074prefigurative
preliterate1365954preliterat__e
preparative1846354pre_parative
preservative2053954pre_servative
proliferative2162354proliferative
rebarbative1852894rebarbative
receptive1648334re_ce_ptive
recitatives1645194recit__atives
recitativi1553744recit__ativi
recitativo1555824recit__ativo
rectorate11411374rectorat__e
redemptive1853304re_demptive
reeducative1753514reeducative
refective1749114re_fe_ctive
reflective1857124refle_ctive
reformative1945674reformative
refractive1846694re__fractive
regulative1446984re_gulative
reintegrate1274954reintegrat__e
reintegrating1554614reintegrating
reintegration14175374reintegration
rejective2148254re_je_ctive
relative11313144r___elative
renovative1645434re_novative
reoperate11410184reoperat__e
reoperating1449024reoperating
reoperation13410904reoperation
repetitive1545404re_petitive
replicative1846084replicative
reprobative1855644reprobative
resentive12410724re_se_ntive
resorptive1544764re_sorptive
respective1747624respe_ctive
restoration11412094restoration
restrictive1646364restrictive
restrive11310924rest_r__ive
retaliative1454984retaliative
retractile1246254re_t_ractile
retreating111414774re_treating
retroactive1645824re_troactive
reverberative2162134reverberative
rotative11310344r_ot__ative
segregative1654064segregative
separative1546974se_parative
tentative1247814tent__ative
tolerative1346254_tolerative
ulcerative1545174_ulcerative
vegetative1744574ve_getative
vibrative1745584_vi_brative
vituperative2072184_vituperative

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.423422437.4
2DLD Change Limit1488191319.01616506.1
3Display Results1311310.0761723.7
 (SQL Overall)1786911319.51518779.9
 
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.