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

118 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
educationists165434(None) 
educationist1555261educationist_
educationalists1892722educationalists
educationeses1661542educationeses
reductionists1654652reduc_tionists
deviationists17104743deviationists
educationalist1763283educationalist_
educationese1551963educationes_e
educations1339233education___s
elocutionists1554313elocutionists
reductionisms1853793reduc_tionisms
reductionist1555993reduc_tionist_
vacationists1754583_vacationists
adoptionists1553924ad_optionists
creationists1476624_creationists
deviationisms1953884deviationisms
deviationist1656154deviationist_
educatedness1652994educatednes_s
education12310204education____
educational1444874education__al
educationally1963314educationally
eductions1268774educ_tion___s
elocutionist1455094elocutionist_
eudaemonists15132444e_udaemonists
evolutionists16145714evolutionists
excursionists2282724excursionists
extortionists2074384extortionists
fictionists1655994_fic_tionists
inflationists1653844inflationists
isolationists1384654isolationists
operationists1556054operationists
recreationists1664374recreationists
reductionism1754324reduc_tionis_m
reductionistic1962124reduc_tionistic
repudiationists18212634repudiationists
salvationists1653564salvationists
selectionists1556024selec_tionists
separationists1664084separationists
vacationist1655904_vacationist_
abolitionists15134225abolitionists
abortionists1454975_abortionists
adoptionisms1753355ad_optionisms
adoptionist1454965ad_optionist_
adulations11310125adulation___s
annexationists21192575annexationists
aquatintists2191565aqu_atintists
associationists17183075associationists
canonists1158515___ca_nonists
cartoonists1384405___cartoonists
coalitionists1583945coalitionists
coeducations1745875coeducation___s
creationisms1685525_creationisms
creationist1379235_creationist_
declinists1344365_dec_li_nists
dedications15310875dedication___s
deductions1467135deduc_tion___s
demolitionists1763475demolitionists
destructionists1894225destruc_tionists
deviationism1854025deviationis_m
devolutionists18144415devolutionists
disunionists1352875_disunionists
divisionists1653275_divisionists
dodecaphonists23181155dodecaphonists
durations10311465_duration___s
educability1946245educabi_li_ty
educatednesses1852835educatednesses
educating1337935educati_n___g
educators1246995educat_o___rs
eduction1169055educ_tion____
emulations12310945emulation___s
equations1839495equ_ation___s
eructations1347235eructation___s
eudaemonisms17132265e_udaemonisms
eudaemonist14123105e_udaemonist_
eudaimonisms17131875e_udaimonisms
euthenists1345895e_u__thenists
evocations15259875evocation___s
evolutionisms18124645evolutionisms
evolutionist15126815evolutionist_
exclusionists2263335exclusionists
excursionist2173205excursionist_
exhibitionists2662515exhibitionists
expansionists2292735expansionists
extortionist1975315extortionist_
exudations18107075exudation___s
fictionist1558025_fic_tionist_
fusionists1354475_fu__sionists
inflationisms1862955inflationisms
inflationist1555295inflationist_
intuitionists1363895intuitionists
isolationisms1563745isolationisms
isolationist1255885isolationist_
liberationists16143695liberationists
medications1649935medication___s
nutritionists1393705nutritionists
operationisms1755095operationisms
operationist1457945operationist_
partitionists1554765partitionists
percussionists18102545percussionists
perfectionists2164015perfectionists
precisionists1754635precisionists
receptionists1754775receptionists
recreationist1555745recreationist_
reductions1359585reduc_tion___s
reeducations1545475reeducation___s
repudiationist17183185repudiationist_
reservationists1873695reservationists
reunionists1154565reu__nionists
revolutionists17145125revolutionists
routinists1046095rou__ti_nists
salvationisms1873005salvationisms
salvationist1554405salvationist_
seductions1366875seduc_tion___s
segregationists17122295segregationists
selectionist1458085selec_tionist_
separationist1555275separationist_
unionists946215__u__nionists
vocationalists1964085_vocationalists

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.420425454.8
2DLD Change Limit1247901188.26615096.8
3Display Results1181180.0931268.8
 (SQL Overall)1786911188.77920354.4
 
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.