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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

78 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
sophism1437871sophism
sophist12311571sophist
sophies12314622sophies
sophisms1546652sophisms
sophists1347292sophists
sophs104916022soph_s_
aphis105917133_aphis_
cochin131313203cochi_n
cochins141413103cochins
copyist1439053copyist
dolphin1345533dolphi_n
dolphins1445653dolphins
foppish1735103foppish
hisn79620933___hisn
kophs145010933koph_s_
mopish134311593mop_ish
morphin1439003morphi_n
morphins1538653morphins
ophite11410563_ophite
opsin7613473_opsi_n
opsins8411713_opsins
option83612713_option
orphism1446183orphism
paphian1437453paphian
phis95724903__phis_
popish133812113pop_ish
poplin10413483popli_n
poplins11313153poplins
qophs19507813qoph_s_
raphis114014323raphis_
roshis9311793roshis_
sapphism1743813sapphism
sapphist1545773sapphist
schism1338173s_chism
schist11312653s_chist
sepsis83011293sepsis_
shin75634313s__hi_n
shins85131043s__hins
shist84829613s__hist
siphon1138463siph_on
siphons1239353siphons
softish13127813softish
solion6616383so_lion
soloist7915893soloist
soph97024203soph___
sophistic1647323sophistic
sophistry1752983sophistry
sophy136611763soph__y
sopite84917713sop_ite
sopors85215203sopors_
soppier112711583soppier
soppiest122511943soppiest
sopping123917203sopping
sops65244563sop__s_
sorption1037513sorption
soths86218633soth_s_
sottish10129443sottish
soubise9118793soubise
sourish10310693sourish
sozin14514543so_zi_n
sozins15510793so_zins
spahis11310383spahis_
speise84614253s_peise
speiss84311643s_peiss
sphinx1866203s_phinx
spin66231303s_p_i_n
spins75327983s_p_ins
sushis9311183sushis_
sylphish1944273sylphish
syphon1436853syph_on
syphons1537503syphons
syphs13519453syph_s_
syrphian1643453syrphian
tophes115218423tophes_
tophi105215303tophi__
tophs105220053toph_s_
tophus115210363tophus_
topis76025833top_is_

Search took 8 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.420425454.8
2DLD Change Limit134027787.01619103.1
3Display Results78780.0332363.6
 (SQL Overall)178691787.46923924.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.