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

92 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
dissertation136609(None) 
dissertations1465891dissertations
dissertating1474792dissertating
dissertational1562572dissertational
dissertator1253072dissertat_or
assentation1146183_assentation
desperation14510113desper_ation
dispensation1555603dispensation
disputation14116743di_sputation
disrelation1248813disre_lation
dissection13158613disse__ction
dissemination1655793dissemination
dissention11188073disse__ntion
dissertate1145983dissertat__e
dissertated1344443dissertat_ed
dissertates1245343dissertat_es
dissertators1352733dissertators
dissipation1447213diss_ipation
dissociation1556643dissociation
assentations1245834_assentations
assertion946724_asser__tion
conservation1749404conservation
deaeration11313014d_eaer_ation
delectation1448554d_electation
denervation1567944d_enervation
dentation10315244d___entation
deportation1449304d_eportation
desecration14410074d_esecration
desertion10410204d_eser__tion
desideration1456394desider_ation
desperations1559524desper_ations
dessertspoon156684dessertspoon
detestation1248364d_etestation
deuteration1249104deuter_ation
dictation12810564di___ctation
dieselization2356054dieselization
dilatation1147394di__latation
dimerization2449084di_merization
disclamation1754244disclamation
discretion1347524di_scr_etion
disinfestation18113614disinfestation
disinflation1656584disinflation
dislocation14147504di_slocation
disorientation1583774disorientation
dispensations1655484dispensations
dispersion1346864disper__sion
disputations15106174di_sputations
disrelations1348504disre_lations
disruption13135734di_s_ruption
disseating121111784disse__ating
dissections14198264disse__ctions
disseminations1755084disseminations
dissension11135724disse__nsion
dissentions12168044disse__ntions
disserting121310854disser__ting
dissimilation1656524dissimilation
dissimulation1655374dissimulation
dissipations1546534diss_ipations
dissociations1656014dissociations
dissolution12145024diss_olution
dissuasion1143844diss__uasion
distention11158874diste__ntion
distillation1347734distillation
distortion1146694distor__tion
distraction1449114di_straction
evisceration1773004eviscer_ation
hibernation1644094hi_bernation
impartation15156104_impartation
impetration1545904_impetration
importation15147124_importation
indentation1248374_indentation
infestation1447044_infestation
innervation1447444_innervation
insertion9410594_inser__tion
interstation12410414_interstation
iteration9515034_i_ter_ation
liberation1269994li_ber_ation
literation10511414li_ter_ation
miscitation1547774mi_scitation
miscreation1547724mi_screation
misquotation23152834misquotation
observation1665054_observation
ostentation1146964_ostentation
pigmentation1754484pigmentation
presentation1448994presentation
preservation1776284preservation
reservation1489144_reservation
seriation9318064___seriation
serration9414064___serration
sustentation1255024sustentation
tessellation1252754tessellation
visitation1348594vi_s_itation

Search took 9 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.783228213.3
2DLD Change Limit124790927.93615724.5
3Display Results92920.0462000.0
 (SQL Overall)178691928.76520386.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.