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

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

90 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
tophes11521842(None) 
topees85519701topees
topes76941761top_es
tophe106718971tophe_
tophs105220051toph_s
tophus115210361tophus
toshes94520101toshes
atopies92816432atopies
boches134618522boches
boshes114721882boshes
copes97747102cop_es
copies104130302copies
copses104922472copses
coshes115022782coshes
dopes84935042dop_es
gopher1239182gopher
gophers1338982gophers
hopes105835642hop_es
joshes165114852joshes
kophs145010932koph_s
kopjes1935362kopjes
lopes76437342lop_es
mopes95134982mop_es
moshes115222872moshes
noshes96618232noshes
opes65942612_op_es
ouphes113614632ouphes
popes95933812pop_es
qophs19507812qoph_s
raphes115117452raphes
ropes75940062rop_es
sophies12314602sophies
sophs104916022soph_s
stopes84525892stop_es
strophes13310592strophes
taches114224172taches
tapes75838602tap_es
tepees84215242tepees
tithes94720212tithes
tobies84521012tobies
tocher114014912tocher
tochers123413092tochers
todies74223552todies
toes46956442to__es
togues76014242togues
toiles63923512toiles
tokes95234972to_kes
toles55147132to_les
tomes76037382to_mes
tones56048662to_nes
tonnes65320852tonnes
topazes1857312topazes
tope65946382top_e_
toped85631312top_ed
topee76029952top_ee
toper75231022top_er
topers85025322topers
toph96326872toph__
tophi105215302toph_i
topics104714582topics
topis76025832top_is
topless92511122topless
topos75726392top_os
topped114617722topped
topper103817602topper
toppers113914602toppers
topples113111652topples
tops66248122top__s
toques154612352toques
torches123715432torches
tores55352672to_res
tories65435882tories
torses64727952torses
tortes64826052tortes
tosses65225392tosses
totes55139682to_tes
tother94117142tother
touches125118342touches
toupees938512toupees
touses64229672touses
towhee122613882towhee
towhees13277792towhees
towies93521192towies
troches123715342troches
tropes84824352trop_es
trophies13413672trophies
tushes94319472tushes
types105721062typ_es
typhus14395712typhus
tythes12419702tythes

Search took 4 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 Filter178691825510.1701051123.5
2DLD Change Limit82551903.03327217.6
3Display Results90900.0303000.0
 (SQL Overall)178691903.23355271.0
 
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.