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

311 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
teapot841676(None) 
teapots939051teapots
teapoy1138111teapoy
depot85727922de_pot
despot93413292despot
leapt75027472leap_t
repot75132622re_pot
respot83117632respot
seaport9315592seaport
sexpot1539542sexpot
tarot55943932t_arot
teabox1536012teabox
teapoys1235962teapoys
teat45963632tea__t
tempo95214972tempo_
tempos103812292tempos
tempt95124842temp_t
tepoy10312162te_poy
tinpot8312512tinpot
trapt76433392trap_t
weapon11288112weapon
zealot15313472zealot
adapt81218553adap_t
apo511142123__apo_
apod78123183__apod
aport75432173__aport
apos65433823__apos
apt57352543__ap_t
beacon10511373beacon
beano75421553beano_
beanos85516513beanos
beast76338643bea_st
beat66168303bea__t
beaut75135213bea_ut
bedpost1247243bedpost
begot84625953be_got
beknot1239763beknot
besot76429713be_sot
bowpot13410073bowpot
capo85829213_capo_
capon95221873_capon
capos94826073_capos
capote10315733_capote
caput9823973_caput
chalot113020133chalot
chapt125827643chap_t
cheapo134810083cheapo_
cheapos14418513cheapos
clapt98027173clap_t
coapt96131523coap_t
deacon9510423deacon
dealt65234283dea_lt
decapod1335433decapod
depart94720563depart
deport94922393de_port
depots94716343de_pots
despots10319683despots
east46659103_ea_st
eat36989053_ea__t
eelpout947783eelpout
epact94921533_epact
epos66723733_e_pos
ergot65422893_ergot
escot75320083_escot
etalon648973etalon
etape74413703etap_e
etapes85415293etapes
expat14313813_expat
expo1349183_expo_
export15412183_export
expos1449203_expos
eyespot1265413eyespot
fagot9323403_fagot
feast85932723fea_st
feat76458223fea__t
fleapit1255993fleapit
gavot9321113_gavot
gemot84024233ge_mot
heap96432893heap__
heaped124516903heaped
heaper114119523heaper
heaps105223223heap_s
heapy135914983heap_y
heart85440743hea_rt
heat77061423hea__t
helot85332683he_lot
heriot9422343heriot
hexapod2043653hexapod
inapt73522693inap_t
inkpot1237813inkpot
jabot14321513_jabot
jetport1646643jetport
kapok10448783_kapok
kaput11717063_kaput
kempt134318463kemp_t
kept106232943ke_p_t
leant56737783lea_nt
leap66032683leap__
leaped94317773leaped
leaper88118943leaper
leaps75522933leap_s
learnt64019253learnt
least56134883lea_st
lept66440883le_p_t
magot8326393_magot
meadow1237403meadow
meant76537203mea_nt
meat66359603mea__t
megapod1344883megapod
merlot83217603merlot
neap66927013neap__
neaps75618323neap_s
neat46356783nea__t
peacoat11412913peacoat
peanut8318183peanut
peart76440753pea_rt
peat65967933pea__t
pepo87622153pe_po_
pepos96620083pe_pos
pot58078433___pot
rapt67245313_rap_t
react74634333rea_ct
readopt10410843readopt
readout8615493readout
reallot7312133reallot
reap65934743reap__
reaped94122453reaped
reaper84223143reaper
reaps75626193reap_s
reason62616333reason
reavow1235723reavow
reboot84119333reboot
reknot10311733reknot
repast83520633repast
replot83818593replot
repo66027543re_po_
report85326013re_port
repos74725793re_pos
repots85621003re_pots
reshot93519633reshot
respots92912763respots
sabot7931773_sabot
sapor75119253_sapor
sapota8310203_sapota
sapote8314353_sapote
seaboot9512333seaboot
seadog838743seadog
seaports1038463seaports
season62714903season
seat47575563sea__t
sepoy10314303se_poy
sept65844363se_p_t
sexpots1636293sexpots
spot65540683__spot
taboo73418093t_aboo
tabor75518393t_abor
tacet75840023t_acet
tacit76333673t_acit
taco67031353t_aco_
tacos77023553t_acos
tact67349033t_a_ct
taint55542283t_aint
talipot949723talipot
talon55824113t_alon
tampon102911233tampon
tanto55724943t_anto
tao38358953t_a_o_
taos45541003t_a_os
tap57663873t_ap__
tapa65129143t_ap_a
tapas74627713t_apas
tape64538143t_ap_e
taped85327423t_aped
taper74829773t_aper
tapes75838603t_apes
tapeta8310693t_apeta
tapir75917063t_apir
tapis75028863t_apis
tappet103820113tappet
taproot9412673t_aproot
taps66050673t_ap_s
taro46846913t_aro_
taroc75721643t_aroc
tarok97921073t_arok
taros55640823t_aros
tarots66422993t_arots
tarpon82812803tarpon
tart47566183t_a_rt
tat37690293t_a__t
taunt55532283t_aunt
tauon54816583t_auon
taut47048963t_a_ut
taxol124011363t_axol
taxon124414663t_axon
tea37353323tea___
teabowl1244143teabowl
teacart91113193teacart
teach105221123tea_ch
teacup1036253teacup
teak85930843tea__k
teaks94222903tea_ks
teal45546503tea__l
teals56234133tea_ls
team66238653tea__m
teamed95418593teamed
teams75726513tea_ms
tear45242883tea__r
teared75722153teared
tearer64822903tearer
tearoom939063tearoom
tears55436463tea_rs
teary85124053tea_ry
teas45851493tea__s
tease55428713tea_se
teased74721153teased
teasel63914983teasel
teaser65421523teaser
teases65426273teases
teashop1246083teashop
teaspoon1044413teaspoon
teated74924023teated
teats55636813tea_ts
teazel15368543teazel
teazle15329553teazle
teepee8314363teepee
teflon937453teflon
telamon936523telamon
telco7511873telco_
telcos8710683telcos
teleost7410523teleost
teleport1048643teleport
telnet6518833telnet
teloi54217383te_loi
telos55424523te_los
telson6310293telson
temp85323333temp__
temped113912893temped
tempeh13357463tempeh
temper103914093temper
tempest1139223tempest
tempi94912203temp_i
temple102811333temple
templet112712003templet
temps95417133temp_s
tempts10439453tempts
tenant6322473tenant
tendon7312033tendon
tenet55542213te_net
tenon53320513te_non
tenor53620253te_nor
tenpin8310583tenpin
tensor63812673tensor
tent46159863te__nt
tenuto648743tenuto
teopan839353teopan
tepa66021683te_p_a
tepal76319583te_pal
tepals85415043tepals
tepas76521683te_pas
tepee74724213te_pee
tepid8314313te_pid
tepoys1137543te_poys
teraph11319093terap_h
tercet83624913tercet
termor84412513termor
terret63425623terret
territ63421373territ
terror63811723terror
test48651623te__st
teston6313303teston
tet39274983te___t
tetrapod1145103tetrapod
text116033933te__xt
that75639323tha__t
tippet103917873tippet
toast55831013toa_st
toot45958883t__oot
topo66932403t_opo_
topoi76018353t_opoi
topos75726393t_opos
torot56139943t_orot
torpor839193torpor
tosspot966883tosspot
tot38884773t___ot
tract75635713tra_ct
trait56940843tra_it
trap67532803trap__
trapan82412973trapan
trapes85024463trapes
traps75727483trap_s
treason748763treason
treat56240353trea__t
tricot8317753tricot
tripod9399853tripod
tripos84014923tripos
trot46351313t__rot
turbot8914263turbot
twat75831513twa__t
typo95418123t_ypo_
typos106015813t_ypos
unapt710421593unap_t
vapor104013093_vapor
weakon13357623weakon
weapons12278603weapons
weason93210823weason
wept95635053we_p_t
wrapt105123183wrap_t
yapok14468153_yapok
yapon104613583_yapon
yeast85327943yea_st
zealots1636763zealots

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 Filter1786911127160.1531167915.0
2DLD Change Limit1127163116.17318259.5
3Display Results3113110.0933344.1
 (SQL Overall)1786913116.41927837.8
 
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.