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

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
recreationists166437(None) 
recreationist1555741recreationist_
creationists1476622__creationists
receptionists1754772rec_eptionists
creationisms1685523__creationisms
creationist1379233__creationist_
receptionist1656403rec_eptionist_
recreations13412253recreation___s
reservationists1873693reservationists
segregationists17122293segregationists
creationism1576464__creationis_m
deviationists17104744de_viationists
educationists1654344_educationists
liberationists16143694liberationists
operationists1556054oper_ationists
perfectionists2164014perfectionists
recreation12413614recreation____
recreational1455164recreation__al
reductionists1654654re_ductionists
repressionist1555324repressionist_
repudiationists18212634repudiationists
reservationist17114334reservationist_
restrictionists1764084restrictionists
revolutionists17145124revolutionists
secessionists1463334sec_essionists
segregationist1692914segregationist_
selectionists1556014se_lectionists
separationists1664084separationists
vacationists1754584vac__ationists
abortionists1454975abor__tionists
annexationists21192575annexationists
cooperationists1963195cooperationists
corruptionists1862455corruptionists
crayonists1544135__cr_a_yonists
creatinines1344045__creati_nines
creations112614545__creation___s
cretinisms1446715__cre_ti_nisms
demolitionists1763475demolitionists
destructionists1894225destructionists
deviationisms1953885de_viationisms
deviationist1656155de_viationist_
devolutionists18144415devolutionists
educationist1555265_educationist_
elocutionists1554315_elocutionists
evolutionists16145715_evolutionists
expressionists2363095expressionists
extortionists2074385_extortionists
fictionists1655995fic___tionists
impressionists1862895impressionists
inflationists1653845_inflationists
integrationists1682575integr_ationists
isolationists1384655_isolationists
liberationist15124735liberationist_
nutritionists1393705nutr_itionists
operationisms1755095oper_ationisms
operationist1457945oper_ationist_
partitionists1554765_partitionists
percussionists18102545percussionists
perfectionisms2363295perfectionisms
perfectionist2055335perfectionist_
perfusionists1863115pe_rfusionists
precisionists1754635prec__isionists
preformationist2272225preformationist_
preservationist2062805preservationist_
procreations1647275procreation___s
projectionists2594115projectionists
protectionists18105145protectionists
receptions1449745rec_eption___s
recitations13314205recitation___s
recordations1548645recordation___s
recreants1146625recrea___n__ts
recreating131214585recreati_n___g
reductionisms1853795re_ductionisms
reductionist1555995re_ductionist_
relativists1464555re__lati_vists
religionists1354395re__ligionists
repudiationist17183185repudiationist_
restrictionisms1963245restrictionisms
restrictionist1665045restrictionist_
resurrectionist1762835resurrectionist_
retreatants1152555retreat_an__ts
reunionists1154565___reunionists
revisionists15144805re__visionists
revolutionises17154005revolutionises
revolutionist16106185revolutionist_
salvationists1653565_salvationists
secessionisms1662775sec_essionisms
secessionist1454755sec_essionist_
secretions12117845secre_tion___s
selectionist1458075se_lectionist_
separationist1555275separationist_
vacationist1655905vac__ationist_

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 Filter178691950240.1231452772.4
2DLD Change Limit95024927.81312162.3
3Display Results92920.140657.1
 (SQL Overall)178691928.07622126.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.