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

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

132 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
postisolation155357(None) 
postinoculation1961843postinoculation
postulation13119133post__ulation
consolation13410984co__nsolation
distillation1347734disti_llation
etiolation1048534__eti_olation
gesticulation1694694gesticulation
instillation1245844insti_llation
isolation9311644____isolation
oscillation1345494_osci_llation
pontification2089014pontification
postabortion1662224postabo_rtion
postilion11117464posti__l__ion
postillion1255634posti__l_lion
postinfection20142634postinfection
postinjection24122414postinjection
postliberation1892054postliberation
postposition1654794post_position
poststimulation1971744poststimulation
postulations14127734post__ulations
pustulation13116624pust__ulation
restimulation1555374restimulation
stimulation1377224__stimulation
stipulation1356334__stipulation
aestivation1447925aesti__vation
articulation1447975_articulation
assimilation1455525_assimilation
cantillation1446695canti_llation
castigation1447975casti__gation
commiseration1964045commiseration
compilation1749315compi__lation
confiscation1945535confis_cation
consolations1449745co__nsolations
constellation1554795const_ellation
constipation1648565consti__pation
contemplation1985265contemplation
contestation1448665contes_tation
continuation1448195conti_nuation
denticulation1654565denticulation
desolation11311405___desolation
destination12413845desti__nation
disconsolation1763415disconsolation
disinflation1656585dis_inflation
dissimilation1656525dissimilation
dissimulation1655375dissimulation
dissolution12145025dis__solution
distillations1446945disti_llations
estimation12410845_esti__mation
estivation1349815_esti__vation
etiolations1147395__eti_olations
expostulation2262615expost__ulation
fasciculation20133565fasciculation
fortification2196925fortification
fossilization2565145fossilization
fustigation1545215fusti__gation
gastrulation1353835gast_rulation
gesticulations1784115gesticulations
insolation10410215___insolation
inspissation1452375inspis_sation
installation1254905inst_allation
instigation1249245insti__gation
instillations1344925insti_llations
isolations10310695____isolations
justification2546095justification
legislation1244285_legis_lation
machicolation22112275machicolation
mastication15610295masti__cation
mortification2087295mortification
motivation1548085mo_ti__vation
mutilation1249755_muti__lation
mystification2346195mystification
nonsolution1154745no__nsolution
notification1749065no_tification
optimisation16193945_optimisation
optimization25166465_optimization
oscillations1445115_osci_llations
osculation1249675_os__culation
ossification17116545_ossification
ostentation1146965_ost_entation
outstation1046165_out_s_tation
participation1955255participation
passivation16104745pas__sivation
patination12312575p_ati__nation
pectination15410335pecti__nation
percolation1549225p__ercolation
personation1349485p__ersonation
pixilation1945915p___ixilation
plasticization2764005plasticization
podsolization25165005po__dsolization
politicization27194205politicization
pollination1348015polli__nation
pontifications2187925pontifications
population14810025po___pulation
position10912195pos_i____tion
postamputation2061715postamputation
postdevaluation2171855postdevaluation
postelection1654545post_election
postgraduation1862045postgraduation
postilions12116285posti__l__ions
postillions1354555posti__l_lions
postirradiation1871145postirradiation
postpollination1971775postpollination
postpositions1753965post_positions
postproduction2162895postproduction
postseason1252745post_s_ea_son
postulating1447505post__ulating
postulational1553915post__ulational
postulator1246015post__ulat_or
potation101716785po_t____ation
potentiation1455975po_tentiation
prostitution1454605prosti__tution
prostration13410795prost___ration
protestation1456365protes_tation
protonation13510435prot__onation
pustulations14115625pust__ulations
restimulations1654645restimulations
restoration11412095rest__oration
reticulation1448055_reticulation
routinization2255835routinization
rustication1349225rusti__cation
sibilation12128775__s_ibilation
simulation1269585__s_imulation
solation8916155_____solation
spiculation1547035__spiculation
stagflation1553145__stagflation
stimulations1456205__stimulations
stipulations1455445__stipulations
stridulation1354775__stridulation
titillation1145045_titi_llation
ventilation1448165venti__lation
vesiculation1746115ves_iculation
violation1238445___vi_olation

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.393454684.5
2DLD Change Limit1247901329.28013447.2
3Display Results1321320.0761736.8
 (SQL Overall)1786911329.74918329.2
 
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.