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

141 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
besteads1130711(None) 
bedsteads1352691bedsteads
bestead10389111bestead_
bedstead1253402bedstead_
beheads1338522be_heads
besmears1234542besmears
bespeaks1643962bespeaks
bespreads1443502bespreads
besteaded1345042besteaded
bested94922752beste_d_
bestuds10326752best_uds
steads74116222__steads
bartends1136793bartends
bastards113310313bastards
basted95227233baste_d_
basters94930303baste_rs
bastes85330383baste__s
beads85429503b___eads
beaters94925033beate_rs
bedspreads1651803bedspreads
bedstands1343503bedstands
bedstraws1542403bedstraws
beebreads1442823beebreads
beefsteaks195953beefsteaks
befleas1236973beflea_s
beglads11127263be_glads
behead1239923be_head_
beleaps1138053be_leaps
belted94020633belte_d_
belters93819413belte_rs
beltways1683903beltways
bemeans1148733be_means
berthas12398763bertha_s
beseems1175913bes_eems
beses75830723bes_e__s
besets85718803bes_e_ts
besieges1146003besieges
besmear1134833besmea_r
bespeak1544573bespea_k
bespread1344183bespread_
besteading1446023besteading
bestial9311643bestia_l
bestiary1344813bestiary
bestirs9311133best_irs
bestowals1443223bestowals
bestows1248863best_ows
bestrews1335603bestrews
bestrid1039973bestrid_
bestride1138613bestride
bestrides1237913bestrides
bestrode1147133bestrode
bestrows1337043bestrows
bests75932613best___s
bestud9439303best_ud_
betas75528763be_t_a_s
betels84515063be_te_ls
betrays12127823be_trays
bettas84913923be_tta_s
betted94721163bette_d_
betters94422093bette_rs
bigheads15145653bigheads
bilsteds1134273bilste_ds
bisters93922603biste_rs
boltheads1545123boltheads
bowheads1745373bowheads
breads95419203b__reads
busloads1144153busloads
bustards11308513bustards
busted95123153buste_d_
busters94724123buste_rs
buttheads1553903buttheads
cestas85018543cest_a_s
cestoids11308273cestoids
deleads9379703de_leads
descends12266983descends
distends10339823distends
enneads834733_enneads
esteems935243_esteems
esters64627733_este_rs
estrays10529403_estrays
estreats839423_estreats
extends15227113_extends
festers104121393feste_rs
gestes75721393geste__s
heptads1335873hept_ads
homesteads1643193homesteads
instead836203instead_
jested144416503jeste_d_
jesters144118193jeste_rs
jetbeads1842483jetbeads
mastheads1545243mastheads
meatheads1545963meatheads
mestees94617753meste_es
mestesos1045223mestesos
misleads11358543misleads
misreads11268923misreads
mistends11419593mistends
nested74720063neste_d_
nesters74422783neste_rs
oersteds934373oerste_ds
pentads1039523pent_ads
pesetas938753peseta_s
pesters93827093peste_rs
redheads1336173redheads
repleads11357203repleads
rereads81512293re_reads
reseals73917663res_eals
reseats74319583res_eats
reseaus74012153res_eaus
resedas839123res_edas
reseeds84012333res_eeds
resends83513713res_ends
respeaks1434953respeaks
respreads1244523respreads
rested74430783reste_d_
resters74130403reste_rs
reteams9339563re_teams
retears72814923re_tears
retreads937823retreads
sestets7911473seste_ts
stead65520273__stead_
steady103510203__steady
steaks104415853__steaks
steals64020063__steals
steams84916903__steams
steeds73814883__steeds
tested74421523teste_d_
testees74215913teste_es
testers74124543teste_rs
testes65125823teste__s
tetrads82910173te_trads
unsteady1243513unsteady
vestals104612333vest_als
vestas95916683vest_a_s
vested104217353veste_d_
vestees103513163veste_es
westerns11328963westerns
westers105221963weste_rs
westwards1643393westwards
zested164214043zeste_d_
zesters163517293zeste_rs

Search took 9 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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621418.67316852.5
3Display Results1411410.0463065.2
 (SQL Overall)1786911418.88920102.5
 
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.