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

141 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
topee7602995(None) 
tepee74724211tepee
tope65946381top_e
toped85631311toped
topees85519701topees
toper75231021toper
topes76941761topes
tophe106718971tophe
toupee8316131toupee
bopeep1236762bopeep
cooee74531022cooee
cope86847382cop_e
coped105036842coped
copen94826432copen
coper95336092coper
copes97747102copes
copse95623922copse
donee66931012donee
dope76038892dop_e
doped95326712doped
doper86128392doper
dopes84935042dopes
dopey116020352dopey
epee64628502_epee
epopee10312502epopee
hope96639672hop_e
hoped115628182hoped
hoper105829142hoper
hopes105835642hopes
kopek1037812kopek
kopje1835272kopje
lope65941922lop_e
loped85128332loped
loper75129232loper
lopes76437342lopes
mope86838042mop_e
moped105424732moped
moper94925922moper
mopes95134982mopes
mopey124821822mopey
nope65934192nop_e
ogee57629882_ogee
ope56845242_op_e
oped76230152_oped
open66427002_open
opes65942612_opes
pee56066512__pee
pope85535612pop_e
popes95933812popes
rope65542912rop_e
roped84630802roped
roper75431912roper
ropes75940062ropes
ropey106021872ropey
rupee7321282rupee
stope74727242stop_e
stoped94721012stoped
stoper84320102stoper
stopes84525892stopes
tape64538142tap_e
taped85327422taped
taper74829772taper
tapes75838602tapes
tee38366872t__ee
teepee8314362teepee
tepees84215242tepees
thee78039062t_hee
three87526912three
toe310166852to__e
toea46732332to_ea
toed56137042to_ed
toes46956442to_es
toffee123311012toffee
togae67020112togae
togue64816302togue
toile54626492toile
toke86738492to_ke
toked105626492toked
token95419312token
toker95924912toker
tokes95234972tokes
tole46052902to_le
toled65934922toled
toles55147132toles
tome67543192to_me
tomes76037382tomes
tone46953742to_ne
toned65435342toned
toneme8312102toneme
toner55336242toner
tones56048662tones
toney86027412toney
tonne54921432tonne
top510560682top__
topaz16315322topaz
topers85025322topers
toph96326872top_h
tophes115218422tophes
tophi105215302tophi
tophs105220052tophs
topi67830392top_i
topic95721502topic
topis76025832topis
topo66932402top_o
topoi76018352topoi
topos75726392topos
topped114617722topped
topper103817602topper
topple104411322topple
tops66248122top_s
toque145113092toque
tore47359322to_re
tores55352672tores
torse55833332torse
torte55431702torte
tote46643672to_te
toted64929482toted
totem74819372totem
toter55932132toter
totes55139682totes
toupees938512toupees
touse55430672touse
towed95134582towed
towel84920522towel
tower85729202tower
towhee122613882towhee
towie85821872towie
townee92815212townee
toyed96019802toyed
toyer84521552toyer
tree47745812t_ree
trope75725802trop_e
tropes84824352tropes
tutee5423522tutee
twee76827082t_wee
tyee75131422t_yee
type96223742typ_e
typed115815452typed
types105721062types
typey135511882typey
yogee9518062yogee

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.346516448.0
2DLD Change Limit538001411.67032215.6
3Display Results1411410.0463065.2
 (SQL Overall)1786911412.06286659.1
 
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.