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

66 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
topsoil97714(None) 
topsail976521topsail
topsoils1095141topsoils
tonsil6311872tons_il
topoi76018352top_oi_
topsails1075092topsails
topsoiled1242642topsoiled
topspin1145112topspin
apostil947903apostil
assoil688543_assoil
consol82614113conso_l
despoil1046523despoil
dossil75110903do_ssil
fossil9379353fo_ssil
opioid9310083_opioid
opsin7613473_ops_in
opsonic1137253_opsonic
opsonin946013_opsonin
podsol946853podso_l
popsie103013053pops_ie
potboil1195463potboil
soil46138833___soil
spoil75818653_sp_oil
subsoil967293subsoil
tahsil936343tahs_il
tatsoi637263tatsoi_
tatsois748373tatsois
tinfoil1044633tinfoil
tipsily1236043tips_ily
tocsin8311003tocs_in
toenail738783toenail
toil46536283t___oil
toluol636903toluo_l
tomfool1254243tomfool
tonsils7310183tons_ils
tonsorial9116743tonsorial
tool46735683to__o_l
topcoat1179313topcoat
topful1136543top_ful
topfull1244153topfull
tophi105215303top_hi_
topi67830393top__i_
topic95721503top__ic
topical1139953topical
topis76025833top__is
topmost1148173topmost
topo66932403top_o__
topos75726393top_o_s
tops66248123tops___
topside1037733topside
topsoiling1343223topsoiling
topspins1244873topspins
topstone1046883topstone
topwork1646343topwork
toroid7416013to_roid
torsi57423363tors_i_
torsion7310803torsion
torso56922143torso__
torsos64815733torso_s
toxoid1438153to_xoid
trefoil1066063trefoil
trysail1044543trysail
turmoil944723turmoil
typhoid1648133typhoid
upboil1096453_upboil
upcoil10126193_upcoil

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 Filter1786911340270.423422437.4
2DLD Change Limit134027667.56317721.4
3Display Results66660.0461434.8
 (SQL Overall)178691668.03222247.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.