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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

138 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
tophs10522005(None) 
kophs145010931kophs
qophs19507811qophs
sophs104916021sophs
topes76941761topes
toph96326871toph_
tophe106718971tophe
tophes115218421tophes
tophi105215301tophi
tophus115210361tophus
topis76025831topis
topos75726391topos
tops66248121top_s
bops86037982bop_s
caphs124515372caphs
copes97747102copes
cops86751372cop_s
dopas85019062dopas
dopes84935042dopes
fops96532682fop_s
goths96513002goths
hopes105835642hopes
hops97942632hop_s
kaphs144911502kaphs
koph135816542koph_
kops107031292kop_s
lochs106715512lochs
lopes76437342lopes
lops66043352lop_s
mopes95134982mopes
mops85940132mop_s
morphs13149432morphs
moths106021552moths
ohs66232312_o_hs
oohs75220692_oohs
oomphs1344722oomphs
oops65232672oop_s
opahs105411982_opahs
opes65942612_opes
ops56641252_op_s
opts68124742_opts
opus66420592_opus
ouphs104311272ouphs
poohs103915712poohs
popes95933812popes
pops86340952pop_s
qoph185911942qoph_
ropes75940062ropes
soph97024202soph_
sophy136611762sophy
sops65244562sop_s
soths86218632soths
staphs114411032staphs
stopes84525892stopes
stops74827282stop_s
syphs13519452syphs
tachs105820932tachs
tapas74627712tapas
tapes75838602tapes
tapis75028862tapis
taps66050682tap_s
techs106915832techs
tepas76521682tepas
teths85418512teths
tipis76019922tipis
tips66436762tip_s
toads65621072toads
tods56141842to_ds
toeas55726422toeas
toes46956442to_es
toffs116016722toffs
tofts84919242tofts
tofus86415422tofus
togas67823002togas
togs57242432to_gs
toils54527492toils
toits55327472toits
tokes95234972tokes
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
tones56048662tones
tongs65928472tongs
tons46553052to_ns
tonus56324302tonus
tools55325242tools
toons55027532toons
tooths96013802tooths
toots55331872toots
top510560682top__
topaz16315322topaz
tope65946382top_e
toped85631312toped
topee76029952topee
topees85519702topees
toper75231022toper
topers85025322topers
topi67830392top_i
topic95721502topic
topics104714582topics
topo66932402top_o
topoi76018352topoi
torahs95115642torahs
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382to_rs
torts56138122torts
torus54329762torus
tosh74826812tosh_
toshes94520102toshes
toss45637972to_ss
totes55139682totes
tots46654122to_ts
toughs105414992toughs
tours55325892tours
touts54830392touts
towns86018882towns
tows78545552to_ws
toyos87519142toyos
toys78036342to_ys
tropes84824352tropes
trophy1438282trophy
troths95414152troths
tups65628762tup_s
types105721062types
typhus14395712typhus
typos106015812typos
typps12549302typps
wops96634152wop_s
yodhs12669012yodhs
yoghs125410592yoghs

Search took 3 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 Filter178691538000.296603685.8
2DLD Change Limit538001381.68631909.8
3Display Results1381380.0304600.0
 (SQL Overall)1786911382.01288812.6
 
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.