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

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

79 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
disintegration1612378(None) 
disintegrations17153631disintegrations
disintegrating1763302disintegrating
disintegrative1962022disintegrative
disintegrator1582052disintegrat_or
disinfestation18113613disinfestation
disintegrate1453343disintegrat__e
disintegrated1662833disintegrat_ed
disintegrates1583123disintegrat_es
disintegrators1691753disintegrators
integration121310493___integration
redintegration16153643redintegration
reintegration14175373_reintegration
desideration1456394desi_de_ration
disinclination1763964disinclination
disinfection1855104disinfe__ction
disinfestations1993504disinfestations
disinflation1656584disin__flation
disinformation2063334disinformation
disintoxication2572554disintoxication
integrations13129474___integrations
itineration1156324_itin_e_ration
redintegrations17143254redintegrations
reintegrations15164784_reintegrations
alliteration1285165alli_te_ration
deconsecration1954785deconsecration
degeneration1447285degen_e_ration
deliberation1546365deli_be_ration
delineation1247765delin_e__ation
denegation1249415d__en_eg_ation
denigration1348465d__en_igration
desecration14410075des___ecration
desegregation1663815desegreg_ation
desiderations1545675desi_de_rations
designation1347485desi___gnation
desperation14510115des__pe_ration
deuteration1249105d__eute_ration
digitization2347685digi_t_ization
disaggregation1862695disaggreg_ation
disambiguation2062225disambiguation
discoloration16124725dis_coloration
discontinuation18103235discontinuation
disinclinations1863585disinclinations
disinfections1954885disinfe__ctions
disinflations1756295disin__flations
disinformations2173305disinformations
disinheriting1853475disinhe_riting
disinhibition1962615disin_hibition
disinteresting1662625disinteresting
disinterring1454205disinte_r_ring
disorientation1583775disorientation
dispensation1555605dis__pensation
disputation14116745disput___ation
disrelation1248815dis__re_lation
dissertation1366095dis__sertation
distention11158875dis__te__ntion
distillation1347735dis__tillation
distortion1146695dis__t_or_tion
distraction1449115dis__t__raction
divination14139235divin____ation
exenteration1955295_exente_ration
incineration1446295incin_e_ration
integrating1349495___integrating
integrative1547125___integrative
integrator1157125___integrat_or
inteneration1248625___inteneration
interaction13411815___inte_raction
iteration9515035___i_te_ration
itinerations1245685_itin_e_rations
literation10511415__li_te_ration
ministration1465835minist__ration
misinformation2172595misinformation
obliteration1453895obli_te_ration
redintegrating1763115redintegrating
redintegrative1962185redintegrative
reintegrating1554615_reintegrating
reintegrative17103255_reintegrative
reiteration11412165_rei_te_ration
visitation1348595visi_t___ation

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 Filter178691950240.343520965.0
2DLD Change Limit95024796.59314412.9
3Display Results79790.0461717.4
 (SQL Overall)178691796.98225593.1
 
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.