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

79 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
topsider114450(None) 
topside1037731topside_
topsiders1243011topsiders
topsides1137201topsides
consider11310392consider
lopsided1244252lopsided
tipsier9268892tipsi_er
torrider936162torrider
apsides103911303_apsides
bossier93712423bossi_er
collider113410413collider
confider1438123confider
considers1238933considers
copier103722893cop_i_er
cosier84423753co_si_er
depside1138403depside_
depsides1238503depsides
diopside1245643diopside_
diopsides1345283diopsides
dopier93515923dop_i_er
dossier83711693dossi_er
goosier83512563goosi_er
gorsier83811073gorsi_er
gossiper1164203gossiper
hoppier143110703hoppi_er
horrider1236523horrider
horsier103013243horsi_er
hosier94219613ho_si_er
insider849733_insider
joyrider1942663joyrider
loppier11369723loppi_er
lousier72411623lousi_er
lowrider1234153lowrider
mopier103914783mop_i_er
mossier94413813mossi_er
mousier93712463mousi_er
noisier759453noisi_er
nosier63716323no_si_er
onside7511803_onside_
osier53518013_o_si_er
outsider9269643outsider
popsie103013053popsi_e_
popsies112816463popsi_es
presider11410423presider
rapider1067903rap_ider
resider84615803_resider
ropier84118803rop_i_er
rosier64221263ro_si_er
solider82912453so_lider
sonsier7711743sonsi_er
soppier112711583soppi_er
spider94516803_sp_ider
stolider936603sto_lider
stupider1133913stup_ider
subsider1138243subsider
tapster9299273taps_ter
tarsier74119253tarsi_er
timider1037093t_imider
tippier113210543tippi_er
tipster9299053tips_ter
toaster74414463toas_ter
toastier846893toastier
toiler63918283to__iler
toluide835263toluide_
toluides935543toluides
tonier65520713to_ni_er
tonsilar843953tonsilar
toper75231023top___er
topline92313183topline_
toplines102412563toplines
topper103817603top__per
topsoiled1242643topsoiled
torsade837593torsade_
torsades937203torsades
tosser64215663to_s_ser
typier1137333typ_i_er
upside9289803_upside_
upsides10319633_upsides
voider103611553vo__ider

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.1561145455.1
2DLD Change Limit146162798.42317352.7
3Display Results79790.0461717.4
 (SQL Overall)178691798.62520717.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.