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

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

289 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
topazes185731(None) 
nopales93812522nopales
tolanes74216312tolanes
topaz16315322topaz__
topees85519702top_ees
topes76941762top__es
tophes115218422top_hes
topples113111652topples
towages1139232towages
amazes175613473_amazes
atomizes192711433atomizes
atopies92816433atop_ies
begazes1937963begazes
blazes174817353_blazes
bolases93315003bolases
bonzes175116103bo_nzes
boozes174916523bo_ozes
boraces113716853boraces
borages103917163borages
boranes93720403boranes
borates94823013borates
boraxes163511633boraxes
bortzes1838223bortzes
brazes175522193_brazes
capizes20410373capizes
coaxes154715633co_axes
comakes154413643comakes
comates114123643comates
compares143816433compares
copalms13367543copalms
copals105018943copa_ls
copays134911273copa_ys
copes97747103cop__es
copies104130313cop_ies
copses104922483cop_ses
cowages13310943cowages
cozes166033243co__zes
cozzes164510893co_zzes
crazes174720133_crazes
dazes155024143__dazes
donates83217223donates
dopants1038433dopants
dopas85019063dopa__s
dopes84935043dop__es
dosages92310803dosages
dotages92311793dotages
dozes155226303do__zes
empales112411433empales
fazes175527213__fazes
feazes184514173_feazes
folates103218453folates
forages114217283forages
gazes155425913__gazes
glazes165315643_glazes
grazes164519643_grazes
hapaxes1936593hapaxes
hazes174928323__hazes
hoaxes163611693ho_axes
homages131011593homages
hopes105835643hop__es
hopples142810713hopples
impales113311763impales
iodates8312903iodates
iodizes173911723iodizes
ionizes162813343ionizes
kopjes1935363kop_jes
koppies153210013koppies
lazes145129573__lazes
lipases9209483lipases
loaves94813853lo_aves
locales93715093locales
locates93218813locates
lopes76437343lop__es
lovages1138033lovages
mazes165632173__mazes
monades103713823monades
mopes95134983mop__es
mopokes1536693mopokes
morales93619403morales
nonages8313843nonages
nopals84914023nopa_ls
notates72817483notates
noyades1136563noyades
oases55330983_o_ases
oaves84925613_o_aves
oozes145418713_o_ozes
opahs105411983_opa_hs
opals75718353_opa_ls
opaques1833643_opaques
opes65942613_op__es
opiates9312143_opiates
opines84820703_opines
opuses84012243_opuses
orates64328613_orates
oyezes1835053_oyezes
paces96741113__paces
pages85235073__pages
pales75753803__pales
panes76148693__panes
pares77164483__pares
pases75346503__pases
pates76047893__pates
paves104833923__paves
paxes144928423__paxes
pipages1289423pipages
pomaces132712123pomaces
pomades123711733pomades
popes95933813pop__es
poppies102816203poppies
popples103011873popples
popsies112816473popsies
potages102416423potages
propanes122415823propanes
pupates113311433pupates
razes145032703__razes
repaves123513653repaves
ropes75940063rop__es
rotates72819773rotates
sleazes162810333sleazes
smazes174311663_smazes
soaves94218673so_aves
socages101012053socages
solaces93116133solaces
solates73523853solates
sophies12314623sophies
sopites93817173sopites
soyuzes1932953soyuzes
spaces104722633_spaces
spades94222583_spades
spaes76029973_spa_es
spales84728103_spales
spares84834553_spares
spates85028173_spates
spazzes1735263_spazzes
stomates10313343stomates
stopes84525893stop__es
stoppages1444693stoppages
stopples1236953stopples
storages9311103storages
storaxes1536883storaxes
stowages1236473stowages
tabes76033923t__abes
taces76237803t__aces
tajes124920693t__ajes
takahes1436173takahes
takes94437793t__akes
tales55451373t__ales
tamales93216153tamales
tames75242013t__ames
tapalos938813tapalos
tapas74627713tapa__s
tapes75838603t__apes
tapises92914013tapises
tares57456563t__ares
tates55444983t__ates
taxes124730823t__axes
teases65426273t_eases
teazel15368543t_eazel
teazels16406893t_eazels
teazles16308923t_eazles
tenaces92814513tenaces
teopans939203teopa_ns
tepals85415043tepa_ls
tepas76521683tepa__s
tepees84215243tep_ees
texases1437573texases
thanes94918983t_hanes
thoraces13118943thoraces
thoraxes1896363thoraxes
thraves13469713thraves
tipples112811253tipples
tiptoes939173tiptoes
tirades8311723tirades
tisanes7311853tisanes
toadies82914863toadies
toads65621073to_a_ds
toasts65914993to_asts
tobies84521023to_bies
todays10458103toda_ys
toddies93011993toddies
toddles93211533toddles
todies74223553to_dies
toeas55726423toea__s
toeplates1147183toeplates
toes46956443to___es
toffees13327083toffees
toffies133210213toffies
togae67020113toga_e_
togaed84711343toga_ed
togas67823003toga__s
togate74515683togate_
togated94410663togated
toggles93710973toggles
togues76014243to_gues
toiles63923513to_iles
tokays13397773toka_ys
tokes95234973to__kes
tolane64316583tolane_
tolans64319273tola_ns
tolars64817943tola_rs
tolas54532773tola__s
toles55147133to__les
tollages92410193tollages
toluates8138903toluates
tomans85419133toma_ns
tomatoes1038613tomatoes
tomes76037383to__mes
tommies113812983tommies
tonemes9311683tonemes
tones56048663to__nes
tongues879693tongues
tonnages9187873tonnages
tonnes65320853to_nnes
tonuses73612193tonuses
toonies73719883toonies
tootles72915603tootles
tootses72910773tootses
topazine1944983topazine
tope65946383top__e_
toped85631313top__ed
topee76029953top__ee
toper75231023top__er
topers85025323top_ers
tophe106718973top_he_
tophs105220053top__hs
tophus115210363top_hus
topiaries1147113topiaries
topics104714583top_ics
topis76025833top__is
topless92511123topless
toplines102412563toplines
topmasts1244973topmasts
topos75726393top__os
topped114617723top_ped
topper103817603top_per
toppers113914603toppers
topple104411323topple_
toppled12348843toppled
tops66248123top___s
topsails1075093topsails
topsides1137203topsides
toques154612353to_ques
torahs95115643tora_hs
toras55540373tora__s
torches123715443torches
tores55352673to__res
tories65435883to_ries
torques16217513torques
torsades937213torsades
torses64727953to_rses
tortes64826053to_rtes
toshes94520103to_shes
tosses65225393to_sses
totaled839693totaled
totalizes18311053totalizes
totals63115163tota_ls
totes55139683to__tes
touches125118343touches
toupees938513toupees
touses64229673to_uses
tousles74113933tousles
touzles16359223touzles
towage1039833towage_
towards1138783towards
towhees13277793towhees
towies93521193to_wies
townees10269783townees
townies103113623townies
towpaths1643113towpaths
towplanes1444683towplanes
toxines142912263toxines
traces85329933t_races
trades75724503t_rades
trapes85024463t_rapes
trapezes1936543trapezes
traves94222743t_raves
triages82613793triages
tropes84824353trop__es
trophies13413683trophies
tropines102214923tropines
tsades74310993t_sades
twaes86513663t_wa_es
tweezes19345703tweezes
types105721063typ__es
tzetzes1532673tzetzes
upases84112903_upases
upgazes1933573upgazes
voyages1435703voyages
zouaves1933893zouaves

Search took 8 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.466383457.1
2DLD Change Limit1340272896.81319672.2
3Display Results2892890.0933107.5
 (SQL Overall)1786912897.37224239.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.