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

158 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
teapoys123596(None) 
teapots939051teapots
teapoy1138111teapoy_
tepoys1137541te_poys
sepoys1138472se_poys
teapot8416762teapo_t
tempos103812292tempo_s
tepoy10312162te_poy_
weapons12278602weapons
apods86316343__apods
apos65433823__apo_s
beacons11410733beacons
beanos85516513beano_s
capons104119503_capons
capos94826073_capo_s
charpoys1834533charpoys
cheapos14418513cheapo_s
deacons10310393deacons
decapods1444623decapods
decoys123911283de_coys
deploys1336523deploys
depots94716343de_pots
despots10319683despots
employs1455523_employs
enjoys1644603_enjoys
envoys1255133_envoys
epos66723733_e_po_s
etalons739073etalons
etapes85415293etap_es
expos1449203_expo_s
heapers123616673heapers
heaps105223223heap__s
heapy135914983heap_y_
hexapods2143403hexapods
jealous1438093jealous
kapoks11347263_kapoks
leapers93716663leapers
leaps75522933leap__s
meadows1337333meadows
megapods1444903megapods
neaps75618323neap__s
peaveys15324063peaveys
pepos96620083pe_po_s
reapers93520453reapers
reaps75626193reap__s
reasons72514943reasons
reavows1335273reavows
repays113813973re_pays
repos74725793re_po_s
repots85621003re_pots
respots92912763respots
sapors84118813_sapors
savoys12427893_savoys
seadogs958643seadogs
seaport9315593seaport
seaports1038463seaports
seasons72614233seasons
seaways13307513seaways
sepoy10314303se_poy_
sexpots1636293sexpots
shamoys15367283shamoys
taboos83815423t_aboos
tabors84517113t_abors
tacos77023553t_aco_s
talons64019433t_alons
tampons112711553tampons
tannoys1055553tannoys
taos45541003t_a_o_s
tapas74627713t_ap_as
tapers84025813t_apers
tapes75838603t_ap_es
tapirs84113173t_apirs
tapis75028863t_ap_is
taps66050673t_ap__s
tarocs84615663t_arocs
taroks106115283t_aroks
taros55640823t_aro_s
tarots66422993t_arots
tarpons92612203tarpons
tauons63412673t_auons
taxols13328633t_axols
taxons134211503t_axons
teabowl1244143teabowl
teabowls1343463teabowls
teabox1536013teabo_x
teaboxes1745063teaboxes
teaches122718353teaches
teacups1133963teacups
teahouse1146073teahouse
teaks94222903tea__ks
teals56234133tea__ls
teams75726513tea__ms
tearers75218233tearers
teargas837013teargas
tearoom939063tearoom
tearooms1047843tearooms
tears55436463tea__rs
teary85124053tea_ry_
teas45851493tea___s
teasels74311313teasels
teasers75317243teasers
teases65426273tea_ses
teashops1345733teashops
teaspoon1044413teaspoon
teaspoons1143843teaspoons
teats55636813tea__ts
teazels16406893teazels
teazles16308923teazles
tedious838443tedious
teepees939263teepees
teflons1036543teflons
telcos8710683telco_s
tellys9348843te_llys
telos55424523te_lo_s
telsons739213telsons
tempehs14325153tempehs
tempers113513013tempers
temples112610893temples
tempo95214973tempo__
temps95417133temp__s
tempts10439453temp_ts
tendons8311473tendons
tenons62916603te_nons
tenors63217753te_nors
tenpins9410073tenpins
tensors72712373tensors
tenuous738483tenuous
teopans939203teopans
tepals85415043te_pals
tepas76521683te_p_as
tepees84215243te_pees
termors94712773termors
terrors73112213terrors
testons7313553testons
tetrapods1244743tetrapods
tomboys1435713tomboys
topos75726393t_opo_s
torpors939383torpors
toys78036343t___oys
trapans92812463trapans
trapes85024463trap_es
trappous1246023trappous
traps75727483trap__s
travois1037883travois
trays85623433tra__ys
treasons848683treasons
tripods10359053tripods
tripos84014923tripo_s
troys86418613t__roys
typos106015813t_ypo_s
vapors113812693_vapors
weakons14287803weakons
weapon11288113weapo_n
weasons102310583weasons
yapoks15346783_yapoks
yapons114411773_yapons
zealots1636763zealots
zealous1637813zealous

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.1401276364.3
2DLD Change Limit1340271586.59320328.7
3Display Results1581580.0632507.9
 (SQL Overall)1786911586.79626293.6
 
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.