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

125 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
receptionists175477(None) 
receptionist1656401receptionist_
recreationists1664372recreationists
receptions1449743reception___s
recreationist1555743recreationist_
reductionists1654653reductionists
secessionists1463333secessionists
selectionists1556023selectionists
adoptionists1553924_adoptionists
creationists1476624_creationists
deceptions1547864deception___s
deviationists17104744deviationists
fictionists1655994fic__tionists
perfectionists2164014perfectionists
precisionists1754634prec_isionists
projectionists2594114projectionists
protectionists18105144protectionists
reception13410324reception____
receptiveness2056124receptivenes_s
receptivity2153874recepti_vi_ty
reductionisms1853794reductionisms
reductionist1555994reductionist_
religionists1354394re_ligionists
reservationists1873694reservationists
reunionists1154564r__eunionists
revisionists15144804re_visionists
revolutionists17145124revolutionists
secessionisms1662774secessionisms
secessionist1454754secessionist_
selectionist1458084selectionist_
telephonists1793314telep_honists
vacationists1754584vac_ationists
abolitionists15134225abolitionists
abortionists1454975_abortionists
accordionists1861495accordionists
adoptionisms1753355_adoptionisms
adoptionist1454965_adoptionist_
annexationists21192575annexationists
cartoonists1384405__cartoonists
coalitionists1583945coalitionists
corruptionists1862455corruptionists
creationisms1685525_creationisms
creationist1379235_creationist_
deception1448325deception____
deceptional1654775deception__al
deceptiveness2155695deceptivenes_s
declinists1344365dec__li_nists
demolitionists1763475demolitionists
determinists1553705determi_nists
deviationisms1953885deviationisms
deviationist1656155deviationist_
devolutionists18144415devolutionists
diversionists1763255diversionists
educationists1654345educationists
elocutionists1554315elocutionists
evolutionists16145715evolutionists
exceptionalisms28162535exceptionalisms
exceptions2146865exception___s
exclusionists2263335exclusionists
excursionists2282725excursionists
extortionists2074385extortionists
fictionist1558025fic__tionist_
geneticists1454385gene_ti_cists
inceptions1448535inception___s
inflationists1653845inflationists
intuitionists1363895intuitionists
isolationists1384655isolationists
liberationists16143695liberationists
nutritionists1393705nutritionists
operationists1556055operationists
partitionists1554765partitionists
perceptions1798195perception___s
percussionists18102545percussionists
perfectionisms2363295perfectionisms
perfectionist2055335perfectionist_
perfusionists1863115perfusionists
preceptorials1962485precept_orials
preceptories1854965precept_ori_es
precisionist1656485prec_isionist_
projectionist2485255projectionist_
protectionisms2094025protectionisms
protectionist17116685protectionist_
recautioning1553765recautioni_ng
recautions1247815recaution___s
recensions1248485recension___s
recentness1245465recent__nes_s
receptivenesses22106055receptivenesses
receptivities2053905receptivities
receptors1356925recept_o___rs
recertifies1644705recerti_fi_es
recessionals1453615recession_als
recessions1248935recession___s
recidivists1792425rec_idi_vists
recipients1444895recip_ien__ts
recitalists1346505rec_it_alists
recreations13412255recreation___s
redemptioners186895redemption_ers
redemptions1643735redemption___s
redeposits1353535redep__osi_ts
reductionism1754325reductionis_m
reductionistic1962125reductionistic
refections151811645refection___s
rejections191510105rejection___s
relativists1464555re_lati_vists
religionist1255665re_ligionist_
repressionist1555325repressionist_
repudiationists18212635repudiationists
resections121513035resection___s
reservationist17114335reservationist_
restrictionists1764085restrictionists
retentions101611115retention___s
reunionist1056175r__eunionist_
revisionisms17143865re_visionisms
revisionist14146525re_visionist_
revolutionises17154005revolutionises
revolutionist16106185revolutionist_
routinists1046095r__outi_nists
salvationists1653565salvationists
scepticisms1963535_scepti_cisms
secessionism1653445secessionis_m
segregationists17122295segregationists
separationists1664085separationists
tectonisms1445575tec__t_onisms
telephonist1694965telep_honist_
vacationist1655905vac_ationist_

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.390458182.1
2DLD Change Limit1247901259.06313769.2
3Display Results1251250.0931344.1
 (SQL Overall)1786911259.54618718.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.