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

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

115 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
fascists133661(None) 
fascisms1545661fascisms
fascist1239211fascist_
assists738472_assists
bassists1037182bassists
casuists1036522casuists
faddists13235542faddists
fascias1258412fasci_as
fasciate1347562fasciate
fasciitis1443542fasciitis
fascines13310142fascines
fascism1436442fascis_m
fascistic1644592fascistic
fascitis1346012fascitis
fauvists1443842fauvists
narcists1078112narcists
racists92613322ra_cists
abscises1246233abscises
accosts11107993_accosts
ageists848493_ageists
agists75713173_a_gists
aorists74215833_aorists
artists74215593_artists
ascents93812553_ascents
asceses938623_asceses
ascesis938373_ascesis
ascites9312603_ascites
ascots85312513_asc_ots
aspises9611643_aspises
assist6314603_assist_
aurists74615783_aurists
autists73814853_autists
baptists1236723baptists
bassist9312743bassist_
cambists1437023cambists
cassises103811743cassises
casuist9411303casuist_
cists76624533___cists
classists11296243classists
coassists11275763coassists
cosmists1237993cosmists
dadaists1045583dadaists
desists83611723des_ists
fabulists1444723fabulists
facets116316653fa_c_ets
facials123310743fa_cials
facias113415803fa_ci_as
facies113921593fa_ci_es
facings134511263fa_cings
facts107021893fa_c__ts
faddisms15264983faddisms
faddist12289643faddist_
faints94818783fa__ints
fanciers13358083fanciers
fancies124018783fanci_es
fanciest133612713fanciest_
fantasts1147113fantasts
farcies125317883farci_es
fasces114914543fasc__es
fascia1148703fasci__a
fasciae1247523fasci_ae
fascial1258303fasci_al
fasciated1546133fasciated
fascicle1554633fascicle
fascicles1664263fascicles
fascinate1447763fascinate
fascinates1547153fascinates
fascine12510583fasci_ne
fascitises1544743fascitises
fashions1437243fashions
fashious1446123fashious
fastest102413723fastest_
fastings124011943fastings
fasts86429683fa___sts
fatalists12310023fatalists
faucets12578443fauc_ets
fauvisms1643743fauvisms
fauvist1336663fauvist_
favisms1535443fa_visms
feists94915313f__eists
feudists1244463feudists
fideists1245543fideists
fiscalists1544673fiscalists
fists85527543f___ists
flautists1253683flautists
florists1138813florists
flutists11256413flutists
foists95413983f__oists
frescoists1552383frescoists
fuguists1243693fuguists
harpists1338103harpists
insists739083ins_ists
laicises1039573laicises
laicisms1247123laicisms
maists85817573ma__ists
mascots113910343masc_ots
masochists1744103masochists
miscasts1238353miscasts
narcisms1267263narcisms
narcist9512443narcist_
palmists12268813palmists
papists112110453pa_pists
pastises103616053pastises
racisms112310813ra_cisms
racist82822793ra_cist_
rapists92510753ra_pists
resists74414923res_ists
sacrists1039563sacrists
sadists83310853sa_dists
schists1248543__schists
shists96515113__shists
tachists1348183tachists
tanists7313653ta_nists
tsarists857303tsarists
waists97415453wa__ists

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621157.92318447.8
3Display Results1151150.0462500.0
 (SQL Overall)1786911158.42221217.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.