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

146 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
sophist1231157(None) 
sophism1437871sophism
sophists1347291sophists
copyist1439052copyist
sapphist1545772sapphist
schist11312652s_chist
shist84829612s__hist
soloist7915892soloist
sophies12314622sophies
sophisms1546652sophisms
sophistic1647322sophistic
sophistry1752982sophistry
sophs104916022soph_s_
soppiest122511942soppiest
aorist64827873ao_rist
aphis105917133_aphis_
baptist11311873baptist
coexist1638583coexist
cohost115217213co_host
consist9316033consist
copyists1545993copyists
cosmist11311333cosmist
dopiest103315993dopiest
euphuist1344573euphuist
foist85730973fo__ist
foppish1735103foppish
hist76551543___hist
hoist86433213ho__ist
holist94723213ho_list
hoppiest152610733hoppiest
hornist102314823hornist
joist125125653jo__ist
kophs145010933koph_s_
lookist1139563lookist
loppiest122410113loppiest
masochist1645583masochist
moist76033583mo__ist
monist84324983mo_nist
mopiest113014293mopiest
mopish134311593mop_ish
mothiest13311033mothiest
oboist8312683_oboist
odist6421913_o_dist
ophite11410563_ophite
orphism1446183orphism
papist102618753pap_ist
phis95724903__phis_
pollist9816603pollist
poloist91016323poloist
popish133812113pop_ish
populist1248203populist
poshest12312423poshest
qophs19507813qoph_s_
raphis114014323raphis_
rapist82520673rap_ist
ropiest93317773ropiest
roshis9311793roshis_
sacrist9315423sacrist
sadist74221353s_adist
sapphism1743813sapphism
sapphists1644113sapphists
sappiest122612583sappiest
schism1338173s_chism
schists1248543s_chists
sepsis83011293sepsis_
sexist133013483s_exist
shiest95821533s__hiest
shift114225143s__hift
shirt84533903s__hirt
shists96515113s__hists
shit76745943s__hi_t
shits84731173s__hits
shoplift1645193shoplift
simplist12249683simplist
sloppiest1345983sloppiest
sloshiest1246683sloshiest
soapiest102412853soapiest
sobeit8315363sobei_t
sodalist9311883sodalist
sodomist1157633sodomist
soffit1237883soffi_t
soffits1335093soffits
softest10310603softest
softish13127813softish
soggiest102711643soggiest
solecist10910783solecist
solipsist1144563solipsist
soloists869153soloists
sonsiest8313033sonsiest
soonest7415593soonest
soothest113312243soothest
sootiest84016753sootiest
soph97024203soph___
sophy136611763soph__y
sopite84917713sop_ite
sopors85215203sopors_
soppier112711583soppier
sopping123917203sopping
sops65244563sop__s_
sorest65028003so_rest
sorriest8413883sorriest
soths86218633soth_s_
sottish10129443sottish
soubise9118793soubise
soupiest102212923soupiest
sourest7515713sourest
sourish10310693sourish
soviet9720153so_viet
spahis11310383spahis_
spait75631603s_pai_t
spaits85017473s_paits
speise84614253s_peise
speiss84311643s_peiss
sphinx1866203s_phinx
spilt75532223s_p_ilt
spirt75032953s_p_irt
spit65545083s_p_i_t
spits74429553s_p_its
splint85223283s_plint
split75729013s_pli_t
splits85416413s_plits
spoilt85016593s_poilt
spriest92718653s_priest
sprint84526793s_print
sprit76736403s_pri_t
sprits85122533s_prits
statist7317723statist
stockist14197713stockist
stylist102110283stylist
subsist9311573subsist
sumoist9311613sumoist
sushis9311183sushis_
sylphish1944273sylphish
syphs13519453syph_s_
tachist12613293tachist
tophes115218423tophes_
tophi105215303tophi__
tophs105220053toph_s_
tophus115210363tophus_
topis76025833top_is_
topmast1138123topmast
topmost1148173topmost
tourist7313203tourist
typist1139823typ_ist
utopist938693utop_ist
whist115322953__whist

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271465.90622693.4
3Display Results1461460.0463173.9
 (SQL Overall)1786911466.35828104.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.