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

93 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
dissertations146589(None) 
dissertation1366091dissertation_
dissertating1474792dissertati_ng
dissertational1562572dissertational
dissertators1352732dissertat_ors
assentations1245833_assentations
desperations1559523desper_ations
dispensations1655483dispensations
disputations15106173di_sputations
disrelations1348503disre_lations
dissections14198263disse__ctions
disseminations1755083disseminations
dissentions12168043disse__ntions
dissertates1245343dissertat__es
dissertator1253073dissertat_o_r
dissipations1546533diss_ipations
dissociations1656013dissociations
assentation1146184_assentation_
assertions1046584_asser__tions
conservations1849094conservations
deaerations12311674d_eaer_ations
delectations1547454d_electations
denervations1657094d_enervations
dentations11413634d___entations
deportations1548464d_eportations
desecrations1559214d_esecrations
desertions1139884d_eser__tions
desiderations1545674desider_ations
desperation14510114desper_ation_
dessertspoons166634dessertspoons
detestations1347584d_etestations
deuterations1348084deuter_ations
dictations1389704di___ctations
dieselizations2455914dieselizations
dilatations1246414di__latations
dimerizations2548544di_merizations
disclamations1853724disclamations
discretions1447224di_scr_etions
disinfestations1993504disinfestations
disinflations1756294disinflations
dislocations15136984di_slocations
disorientations1683624disorientations
dispensation1555604dispensation_
dispersions1446454disper__sions
disputation14116744di_sputation_
disputatious15102324di_sputatious
disrelation1248814disre_lation_
disruptions14125684di_s_ruptions
disseating121111784disse__ati_ng
dissection13158614disse__ction_
dissemination1655794dissemination_
dissensions12175574disse__nsions
dissention11188074disse__ntion_
dissentious12184474disse__ntious
dissertate1145984dissertat___e
dissertated1344444dissertat__ed
disserting121310854disser__ti_ng
dissimilations1755864dissimilations
dissimulations1754904dissimulations
dissipation1447214diss_ipation_
dissociation1556644dissociation_
dissolutions13144924diss_olutions
dissuasions1243524diss__uasions
distentions12178844diste__ntions
distillations1446944distillations
distortions1246614distor__tions
distractions1548754di_stractions
eviscerations1882704eviscer_ations
hibernations1744054hi_bernations
impartations16135434_impartations
impetrations1645444_impetrations
importations16156144_importations
indentations1347884_indentations
infestations1546624_infestations
innervations1546924_innervations
insertions10410344_inser__tions
iterations10413824_i_ter_ations
liberations1358944li_ber_ations
literations11610584li_ter_ations
miscitations1647054mi_scitations
miscreations1647064mi_screations
misquotations24182724misquotations
observations1785014_observations
ostentations1246124_ostentations
pigmentations1854094pigmentations
presentations1548134presentations
preservations1895544preservations
reservations1588584_reservations
seriations10316684___seriations
serrations10313094___serrations
sustentations1354784sustentations
tessellations1352614tessellations
visitations1447674vi_s_itations

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 Filter178691950240.360496363.9
2DLD Change Limit95024935.18618323.2
3Display Results93930.0462021.7
 (SQL Overall)178691935.59231954.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.