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

131 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
deviationists1710474(None) 
deviationisms1953881deviationisms
deviationist1656151deviationist_
deviationism1854022deviationis_m
deviations14311163deviation___s
devolutionists18144413devolutionists
divisionists1653273divi_sionists
educationists1654343educationists
revisionists15144803revi_sionists
creationists1476624_creationists
demolitionists1763474demolitionists
deviation13312394deviation____
devolutionist17135154devolutionist_
diversionists1763254diversionists
divisionisms1862774divi_sionisms
divisionist1554634divi_sionist_
educationist1555264educationist_
evolutionists16145714_evolutionists
fictionists1655994__fictionists
inflationists1653844inflationists
isolationists1384654isolationists
operationists1556054operationists
receptionists1754774receptionists
recreationists1664374recreationists
reductionists1654654reductionists
religionists1354394reli_gionists
repudiationists18212634repudiationists
revisionisms17143864revi_sionisms
revisionist14146524revi_sionist_
revolutionists17145124revolutionists
salvationists1653564salvationists
selectionists1556024selectionists
separationists1664084separationists
vacationists1754584_vacationists
abolitionists15134225abolitionists
abortionists1454975_abortionists
adoptionists1553925_adoptionists
annexationists21192575annexationists
associationists17183075associationists
aviations12311555_aviation___s
behaviorists2081475be_haviorists
coalitionists1583945coalitionists
creationisms1685525_creationisms
creationist1379235_creationist_
dealations11311375dealation___s
decimations16410165decimation___s
declinists1344365de__cli_nists
dedications15310875dedication___s
defeatists1443425defeat___ists
deflations1439715deflation___s
delations102616595de_lation___s
demolitionist1654515demolitionist_
demonists1248705de____monists
dentations11413635dentation___s
depictions1546895depiction___s
depilations14310905depilation___s
derivations15611495derivation___s
dermatitises1553265dermati_tises
dermatologists18134925dermatologists
destructionists1894225destructionists
determinists1553705determi_nists
deviants1236735devia___n__ts
deviating14311085deviati_n___g
deviators1358535deviat_o___rs
devotionals1552995dev_otion_als
devotions1356595dev_otion___s
diabolists1354465d__ia_bolists
dialogists1265605d__ia_logists
diffusionists2082265diffusionists
disunionists1352875d_isunionists
diversionist1654515diversionist_
divinations15128415divination___s
divisionism1753205divi_sionis_m
educationalists1892725educationalists
educationeses1661545educationeses
elocutionists1554315elocutionists
eudaemonists15132445_eudaemonists
evictions14228625_eviction___s
evolutionisms18124645_evolutionisms
evolutionist15126815_evolutionist_
exhibitionists2662515exhibitionists
expansionists2292735_expansionists
extortionists2074385extortionists
fictionist1558025__fictionist_
inflationisms1862955inflationisms
inflationist1555295inflationist_
integrationists1682575integrationists
intuitionists1363895intuitionists
isolationisms1563745isolationisms
isolationist1255885isolationist_
legitimists1463465legi_ti_mists
levigations1546215levigation___s
levitations1448295levitation___s
liberationists16143695liberationists
mediations13310985mediation___s
metafictionists2291815metafictionists
negativists1553615ne_gati_vists
nutritionists1393705nutritionists
obviations1545465obviation___s
operationisms1755095operationisms
operationist1457945operationist_
partitionists1554765partitionists
pediatrists1454065pediat__rists
perfectionists2164015perfectionists
perfusionists1863115perfusionists
precisionists1754635preci_sionists
receptionist1656405receptionist_
recreationist1555745recreationist_
reductionisms1853795reductionisms
reductionist1555995reductionist_
relativists1464555re_lati_vists
religionist1255665reli_gionist_
repudiationist17183185repudiationist_
reservationists1873695reservationists
restrictionists1764085restrictionists
reunionists1154565re__unionists
revisionism16144815revi_sionis_m
revolutionises17154005revolutionises
revolutionist16106185revolutionist_
salvationisms1873005salvationisms
salvationist1554405salvationist_
secessionists1463335secessionists
segregationists17122295segregationists
selectionist1458085selectionist_
semioticists1683325semioti_cists
sensationalists15244615sensationalists
separationist1555275separationist_
seriations10316685seriation___s
vacationist1655905_vacationist_
violinists1344445__violi_nists
vivisectionists2371525vivisectionists

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.1401276364.3
2DLD Change Limit1247901318.18615244.3
3Display Results1311310.0801637.5
 (SQL Overall)1786911318.40621257.6
 
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.