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

81 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
scintillators156201(None) 
scintillator1462101scintillator_
scintillates1482882scintillat_es
scintillations1662752scintillations
scintillas1263363scintilla___s
scintillate1363093scintillat__e
scintillated1562423scintillat_ed
scintillating1662193scintillating
scintillation1593003scintillation
cantillates1346634_cantillat_es
cantillations1545734_cantillations
conciliators1695394_conciliators
continuators14105634_continuators
oscillators13113644osc___illators
scintilla1153754scintilla____
scintillae1272814scintilla___e
scintillant1352954scintilla__nt
scintillantly18101404scintillantly
scintillometers197854scintillometers
sibilators1245714s_i_bi_lators
ventilators14105064_venti_lators
activators1545955ac__ti_vators
amontillados156575amontillado_s
annihilators1552775annihi_lators
assimilators14123905assi_mi_lators
cantillate1247345_cantillat__e
cantillated1445125_cantillat_ed
cantillating1565055_cantillating
cantillation1446695_cantillation
captivators1853625_capti_vators
castigators1445545_casti_gators
centiliters1343925_centi_liters
centillions1353975_centill_ions
circulators1545735_ci_rculators
citators10310255_ci_t___ators
collators11410345_c___ollators
conciliator1595595_conciliator_
conciliatory1994215_conciliatory
confiscators19113685_confiscators
constellatory1862595_constellatory
contemplators1953575_contemplators
continuator1386015_continuator_
cultivators1653845_culti_vators
defibrillators2061215defibrillators
distillates1246155_distillat_es
distillations1446945_distillations
inculcators1544185__inculcators
indicators1348615__indi_cators
infiltrators1552745__infiltrators
inflators1257715__in__flators
inhalators1344935__in_halators
initiators10127315__in_itiators
inoculators1345635__inoculators
insinuators1154145__insinuators
instigators1245925__insti_gators
instillations1344925__instillations
insulators1047265__in_sulators
integrators1246525__integrators
intimaters1297855__inti_maters
intimidators1554165__intimidators
invigilators1653185__invigilators
litigators1145385_li_ti_gators
mitigators1345375_mi_ti_gators
mutilators1266455__muti_lators
oscillator12133715osc___illator_
oscillatory16133115osc___illatory
quintillions2152315quintill_ions
scintillometer189975scintillometer_
sibilator1145705s_i_bi_lator_
simulators1246105s_i__mulators
sonicators1277065s_on_i_cators
stimulators1344665sti__mulators
stipulators1354055sti__pulators
syndicators1753505s_yndi_cators
titillates1045135_ti_tillat_es
titillations1244445_ti_tillations
vacillators1653345__vacillators
ventilator13115115_venti_lator_
ventilatory17114125_venti_latory
vindicators1744535_vindi_cators
vitiators1246925_vi_ti__ators

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 Filter1786911247900.406440125.6
2DLD Change Limit124790818.84314111.7
3Display Results81810.0461760.9
 (SQL Overall)178691819.29519224.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.