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

254 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
teapots93905(None) 
teapot8416761teapot_
teapoys1235961teapoys
depots94716342de_pots
despots10319682despots
repots85621002re_pots
respots92912762respots
seaports1038462seaports
sexpots1636292sexpots
tarots66422992t_arots
teapoy1138112teapo_y
teats55636812tea__ts
tempos103812292tempo_s
tempts10439452temp_ts
tepoys1137542te_poys
weapons12278602weapons
zealots1636762zealots
adapts9107813adap_ts
apods86316343__apods
apos65433823__apo_s
beacons11410733beacons
beanos85516513beano_s
beasts84519723bea_sts
beats76042243bea__ts
beauts86015283bea_uts
bedpost1247243bedpost
bedposts1343873bedposts
beknots1335083beknots
besots86415453be_sots
bowpots1446023bowpots
capons104119503_capons
capos94826073_capo_s
capote10315733_capote
capotes11314643_capotes
cheapos14418513cheapo_s
coapts104614003coap_ts
deacons10310393deacons
decapods1444623decapods
departs104310683departs
deports105012883de_ports
depot85727923de_pot_
despot93413293despot_
easts57530323_ea_sts
eats47054873_ea__ts
eelpouts1044323eelpouts
epacts105010393_epacts
epos66723733_e_po_s
ergots74512373_ergots
escots84211743_escots
etalons739063etalons
etapes85415293etap_es
expats1537683_expats
exports1647983_exports
expos1449203_expo_s
eyespots1362973eyespots
fagots1039963_fagots
feasts95116093fea_sts
feats86432753fea__ts
fleapits1363253fleapits
gavots1038103_gavots
gemots93712153ge_mots
heapers123616673heapers
heaps105223223heap__s
hearts96218943hea_rts
heats85838403hea__ts
helots95217703he_lots
heriots10312063heriots
hexapods2143403hexapods
inkpots1335173inkpots
jabots1538883_jabots
jealous1438093jealous
jetports1743533jetports
kapoks11347263_kapoks
leapers93716663leapers
leaps75522933leap__s
leapt75027473leap_t_
leasts64616413lea_sts
magots9312363_magots
meadows1337333meadows
meats75034053mea__ts
megapods1444893megapods
merlots92710123merlots
neaps75618323neap__s
neats55931903nea__ts
peacoats1247833peacoats
peanuts936993peanuts
peats76140193pea__ts
pepos96620083pe_po_s
pots66452363___pots
reacts83616603rea_cts
readopts1146483readopts
readouts938883readouts
reallots837983reallots
reapers93520453reapers
reaps75626193reap__s
reasons72514943reasons
reavows1335273reavows
reboots93512093reboots
reknots1136783reknots
repasts93611933repasts
replots93412633replots
reports94916213re_ports
repos74725793re_po_s
repot75132623re_pot_
respot83117633respot_
sabots8314693_sabots
sapors84118813_sapors
sapota8310203_sapota
sapotas939603_sapotas
sapote8314353_sapote
sapotes9313933_sapotes
seaboots1047093seaboots
seadogs958643seadogs
seaport9315593seaport
seasons72614233seasons
seats54844343sea__ts
sepoys1138473se_poys
septs75420603se_p_ts
sexpot1539543sexpot_
spots74424103__spots
taboos83815423t_aboos
tabors84517093t_abors
tacos77023553t_aco_s
tacts76524123t_a_cts
taints64520533t_aints
talipots1045613talipots
talons64019423t_alons
tampons112711553tampons
taos45541003t_a_o_s
tapas74627713t_ap_as
tapers84025813t_apers
tapes75838603t_ap_es
tapeta8310693t_apeta
tapirs84113173t_apirs
tapis75028863t_ap_is
tappets113610013tappets
taproots1047253t_aproots
taps66050673t_ap__s
tarocs84615663t_arocs
taroks106115283t_aroks
taros55640823t_aro_s
tarot55943933t_arot_
tarpons92612203tarpons
tarts57242023t_a_rts
tats46858133t_a__ts
taunts65715663t_aunts
tauons63412673t_auons
tauts56125513t_a_uts
taxols13328633t_axols
taxons134211503t_axons
teabowl1244143teabowl
teabowls1343463teabowls
teabox1536013teabo_x
teaboxes1745063teaboxes
teacarts10116073teacarts
teaches122718353teaches
teacups1133963teacups
teahouse1146073teahouse
teaks94222903tea__ks
teals56234133tea__ls
teams75726513tea__ms
tearers75218233tearers
teargas837013teargas
tearoom939063tearoom
tearooms1047843tearooms
tears55436463tea__rs
teas45851493tea___s
teasels74311313teasels
teasers75317243teasers
teases65426273tea_ses
teashops1345733teashops
teaspoon1044413teaspoon
teaspoons1143843teaspoons
teat45963633tea__t_
teazels16406883teazels
teazles16308913teazles
tedious838443tedious
teepees939263teepees
teflons1036533teflons
telcos8710683telco_s
teleost7410523teleost
teleosts846423teleosts
teleports1145433teleports
telnets738373telnets
telos55424523te_lo_s
telsons739203telsons
tempehs14325153tempehs
tempers113513013tempers
tempest1139223tempest
tempests1234443tempests
temples112610893temples
templets12226143templets
tempo95214973tempo__
temps95417133temp__s
tempt95124843temp_t_
tenants7311013tenants
tendons8311473tendons
tenets65518953te_nets
tenons62916603te_nons
tenors63217753te_nors
tenpins9410073tenpins
tensors72712373tensors
tents56434213te__nts
tenuous738473tenuous
tenutos736623tenutos
teopans939203teopans
tepals85415043te_pals
tepas76521683te_p_as
tepees84215243te_pees
tepoy10312163te_po_y
tercets93512443tercets
termors94712773termors
terrets72913573terrets
territs72714493territs
terrors73112203terrors
testons7313553testons
tests56530193te__sts
tetrapods1244713tetrapods
tets45847453te___ts
texts125515043te__xts
tinpot8312513tinpot_
tippets11339373tippets
toasts65914993toa_sts
toots55331873t__oots
topos75726393t_opo_s
torpors939373torpors
tosspots1044563tosspots
tots46654123t___ots
tracts85019073tra_cts
traits65121983tra_its
trapans92812463trapans
trapes85024463trap_es
trappous1246013trappous
traps75727483trap__s
trapt76433393trap_t_
travois1037873travois
treasons848673treasons
treats64821693trea__ts
tricots9311563tricots
tripods10359053tripods
tripos84014923tripo_s
trots56629943t__rots
turbots988023turbots
twats86616603twa__ts
typos106015813t_ypo_s
vapors113812693_vapors
weakons14287803weakons
weapon11288113weapo_n
weasons102310583weasons
yapoks15346783_yapoks
yapons114411773_yapons
yeasts96413053yea_sts
zealot15313473zealot_
zealous1637813zealous

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.1701051123.5
2DLD Change Limit1340272547.03319056.9
3Display Results2542540.0932731.2
 (SQL Overall)1786912547.29624491.6
 
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.