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

399 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
tipster929905(None) 
hipster12288781hipster
tapster9299271tapster
tipsier9268891tipsier
tipsters10278511tipsters
bister84922762bi_ster
diaster82813312diaster
diester83013682diester
fibster12146532fibster
gypster1333952gypster
hipsters13268792hipsters
kiester11329972kiester
lister64527252li_ster
minster93914322minster
mister84728562mi_ster
piaster93012882piaster
quipster1933932quipster
sister64421582si_ster
tapsters10318802tapsters
taster64930572t_aster
tester64227152t_ester
thirster1135672thirster
tighter112910692tighter
tilter63417692ti_lter
tinter63923642ti_nter
tipper103918412tip_per
tippier113210542tippier
tippler11348342tippler
titer55430612ti__ter
titter63421162ti_tter
toaster74414462toaster
truster73114312truster
tryster10369512tryster
twister10308952twister
apter76120203_ap_ter
aster55434893__aster
attester836503attester
baster85333593_baster
bilsted1038033bilsted
bimester1236163bimester
bisters93922613bi_sters
bistre83815023bi_stre
biter75030033bi__ter
bitsier9379073bitsier
bitter84622673bi_tter
blaster94017303blaster
blister94415313blister
bluster94215313bluster
boaster94616433boaster
bolster93713423bolster
booster94314553booster
burster9310293burster
buster84726493_buster
caster85232573_caster
chaster124718503chaster
cipher133710263cip_her
cisted95217523ci_sted
cistern93310703ci_stern
citer74827333ci__ter
cluster94013333cluster
clyster12317453clyster
coaster94219043coaster
copter109822013cop_ter
coster84331293_coster
dabster1036703dabster
dempster1355773dempster
diastem10318043diastem
diasters92913183diasters
diesters92513603diesters
dieter73516773di_eter
digester10258433digester
dilater83515653dilater
diluter8319663diluter
dimeter10411893dimeter
diopter1038473diopter
dipper114017793dip_per
dippier123111393dippier
diptera1037213dip_tera
disaster949943disaster
disputer1137973disputer
ditsier83010293ditsier
dopester1137253dopester
dumpster1344053dumpster
duster74919723_duster
easter65027983_easter
epistler1044833epistler
ester54727713__ester
faster94625773_faster
feaster10812983feaster
fester94723513_fester
fibsters13126413fibsters
fighter143010773fighter
filister1137403filister
filter94517633fi_lter
fisher124917143fi_sher
fisted104218703fi_sted
fitter94120033fi_tter
fluster103913063fluster
foster94322223_foster
gagster9317633gagster
gaster75027353_gaster
gipper114215303gip_per
gipsied1135873gipsied
gipsies1039903gipsies
glister84013343glister
grister83915413grister
gypsters1434023gypsters
hamster12810423hamster
heister103613623heister
hinter94021303hi_nter
hipper133818023hip_per
hippier143212103hippier
hisser94713793hi_sser
hissier103410503hissier
histed104420243hi_sted
hitter94419863hi_tter
hoister103714203hoister
holster103512213holster
hoopster1335543hoopster
imposter12288163imposter
imputer1136533imputer
instar6310013_instar
instep838193_instep
inter55028493_i_nter
irater65218353_irater
issuer646623_issuer
jester134319153_jester
jilter133512513ji_lter
jitter133314993ji_tter
jouster143311043jouster
juster134617013_juster
keester11319913keester
keister113011573keister
keyster14256153keyster
kiesters123310153kiesters
kilter103714343ki_lter
kipper143414213kip_per
kisser104212453ki_sser
kiter95523213ki__ter
klister113410643klister
lamster9109913lamster
lapser84113143laps_er
laster64830633_laster
leister73212753leister
lifter93814813li_fter
lighter113113443lighter
limiter92710853limiter
limpsier1234433limpsier
linter64625343li_nter
lipper104219633lip_per
lippier112710573lippier
lisper84114433li_sper
listed74322833li_sted
listee64223063li_stee
listel64214743li_stel
listen64816813li_sten
listers74026533li_sters
liter54736343li__ter
litter64324853li_tter
lobster9288853lobster
luster64023673_luster
master84831343_master
meister93114163meister
milter84921233mi_lter
minister10410363minister
minsters103813923minsters
minter84425103mi_nter
minuter93510413minuter
miser75430403mi_s_er
missteer1037223missteer
misstep11158463misstep
misted93625823mi_sted
misterm114314513mi_sterm
misters93927513mi_sters
mistier93418713mi_stier
miter75734793mi__ter
mobster11299213mobster
moister94015373moister
monster93214603monster
munster93710523munster
muster84724523_muster
nester64124183_nester
nipper103715713nip_per
nippier11319833nippier
niter55028973ni__ter
oldster896573oldster
ouster64223733_ouster
oyster94111703_oyster
paster85734373_paster
pater74740723__pater
penster92811953penster
pester84827593_pester
peter74427593__peter
piasters102912813piasters
piastre9307893piastre
pilaster1038163pilaster
pilsner935343pilsner
pinaster1037113pinaster
piper96523193pip__er
pipestem1443743pipestem
pipier104913983pip_ier
pisher114317753pi_sher
pisser84416383pi_sser
piste75824603pi_ste_
pistes85325633pi_stes
plaster93318693plaster
poster84129173_poster
prester93519623prester
punster92911103punster
quester161410023quester
quipsters2043593quipsters
raster64731443_raster
rester63832433_rester
righter113212383righter
rimester1037813rimester
rinser64317213rins_er
rioter64817283ri_oter
ripener937903ripener
riper74328403rip__er
riposte9269623riposte_
riposted11216933riposted
ripostes10239083ripostes
ripper103518653rip_per
rippler113210103rippler
ripstop1174763ripstop
riser55431053ri_s_er
risker105414493ri_sker
ritter63822423ri_tter
riveter10208753riveter
roaster74116663roaster
roister73516203roister
rooster74415173rooster
roster64329083_roster
rouster73517083rouster
royster103110533royster
shyster13116563shyster
sifter94516233si_fter
sighter113412113sighter
sinister838583sinister
sinter63625923si_nter
sipper103920993sip_per
sissier73711363sissier
sisters73721593si_sters
sitter63323383si_tter
spinster1036683spinster
spitter94015183spitter
stinter73614513sti_nter
stipites1039653stipites
stippler1235543stippler
taper74829773tap__er
taperer92511793taperer
tapper104419613tap_per
tarsier74119253tarsier
tarter64023563t_arter
taste55127233t_aste_
tasted74123973t_asted
tasters74225643t_asters
tastes64126423t_astes
tastier711817093t_astier
tater54138613t__ater
tatter64024573t_atter
taunter73111453taunter
tauter64318023t_auter
teamster1036293teamster
teaser65421523teas_er
teeter65420313t_eeter
tempter11358213tempter
tenser64919433tens_er
tenter64623933t_enter
terser67317823ters_er
tested74421523t_ested
testee64323303t_estee
testers74124543t_esters
testes65125823t_estes
testier74015643t_estier
tetter64322453t_etter
theater104014253theater
thirsted1235213thirsted
thirsters1235233thirsters
thirstier1243693thirstier
thruster1135793thruster
ticker124321503ti_cker
tickler133612653tickler
tiddler93110003tiddler
tidier73515113ti_dier
tier44936143ti___er
tiger65718633ti__ger
tighten11288973tighten
tiler56131023ti__ler
tiller64222543ti_ller
tilted74616863ti_lted
tilters73315953ti_lters
timber104012683ti_mber
timer75626043ti__mer
timider1037093timider
tincted1037273tincted
tinder73821803ti_nder
tingler83613343tingler
tinier63622233ti_nier
tinker103619923ti_nker
tinkler113610543tinkler
tinner64119963ti_nner
tinnier72910143tinnier
tinsel639443tins_el
tinted74419533ti_nted
tinters74221113ti_nters
tipped114418263tip_ped
tippers113414353tip_pers
tippet103917873tip_pet
tippets11339373tippets
tipple103411913tipple_
tippled12358393tippled
tipplers12336353tipplers
tipples112811253tipples
tips66436763tips___
tipsheet1345833tipsheet
tipsiest10228953tipsiest
tipsily1236043tipsily
tipstaff1643003tipstaff
tipstaves1443353tipstaves
tipstock1643733tipstock
tipsy106010503tips__y
tiptoe838283tip_toe
tiptoed1036143tiptoed
tiptoes939173tiptoes
tiptop1036103tip_top
tireder837703tireder
tissue637333tissue_
tissued835583tissued
tissues737463tissues
tissuey1033663tissuey
titers64526413ti__ters
titfer9409523ti_tfer
tither94920283ti_ther
titre54619393ti__tre
titters74219623ti_tters
toasted84011923toasted
toasters83912723toasters
toastier846893toastier
tooter64420803t_ooter
toper75231023top__er
topper103817603top_per
topsider1144503topsider
tosser64215663t_osser
toter55932133t__oter
totter65021463t_otter
touter63821033t_outer
trasher104416133trasher
treater74219833treater
trickster15265703trickster
trimester1145823trimester
trimeter10310083trimeter
tripper113711923trip_per
trippier1246623trippier
triste63818643triste_
triter65120593t_riter
trotter73312253trotter
trusser74010263trusser
trusted83412793trusted
trustee73514443trustee
trusters83112263trusters
trustier8268683trustier
trustor7238413trustor
tryste9399583tryste_
trysted11428273trysted
trysters11298373trysters
trystes10419993trystes
tufter9319933t_ufter
tusker104212193t_usker
tusser64615833t_usser
tweeter10288533tweeter
twisted11277433twisted
twisters11268173twisters
twistier1134813twistier
twitter10278093twitter
typier1137333typ_ier
ulster63712103_ulster
upstep1035503_upstep
upstir835383_upstir
vaster94521023_vaster
viper105017303vip__er
visiter1038863visiter
waister103812383waister
waster95228943_waster
webster1236093webster
wester94222893_wester
winter94222803wi_nter
wiper105421293wip__er
wiser85522803wi_s_er
wisher123617063wi_sher
wispier12249403wispier
wisted104120273wi_sted
wrester102812413wrester
xyster16366803_xyster
yester93417983_yester
zester153617793_zester
zipper193813123zip_per
zippier20308193zippier
zoster153715853_zoster

Search took 7 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.406440125.6
2DLD Change Limit1340273996.32621186.7
3Display Results3993990.1402850.0
 (SQL Overall)1786913996.87226002.8
 
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.