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 “spean” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

127 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
spean7462051(None) 
pean66147171_pean
skean94415621skean
span65234661sp_an
speak114618671speak
speans85417141speans
spear75821061spear
apeak115513452apeak
apian75018332apian
aspen75216092aspe_n
bean66443862_bean
clean75420412clean
dean56039482_dean
glean65818202glean
jean116629282_jean
lean46345242_lean
mean65538092_mean
ocean71212962ocean
open66427002ope_n
paean77222722paean
pan58466452_p_an
pea56657242_pea_
peag75431342_peag
peak106535202_peak
peal68648102_peal
peans75437642_peans
pear69745232_pear
peas65755062_peas
peat65967932_peat
pecan91919032_pecan
peen65938082_peen
pein65834942_pein
pekan111613972_pekan
pen56558842_pe_n
peon65635242_peon
pian66136102_pian
plan65833942_plan
quean143612842quean
saran53730312saran
scan65530452s_can
scena74815782scena
sea36161292s_ea_
seal45654372s_eal
seam66645972s_eam
sear47353842s_ear
seas45755272s_eas
seat47575562s_eat
sedan65620422sedan
seen46943122s_een
sen36058522s_e_n
sepal77723002sepal
sewan85921292sewan
sewn76124332s_ewn
shea76031572shea_
sheaf115424122sheaf
sheal84927702sheal
shear85424832shear
sheas86331792sheas
sheen85023312sheen
shewn115715702shewn
skeane104611372skeane
skeans104512912skeans
skeen94817402skeen
skein94814412skein
smear74416392smear
sneak96016172sneak
sneap75514822sneap
solan55328152solan
soman75024902soman
spa55730812sp_a_
spae65034322sp_ae
spaed85522272spaed
spaes76029972spaes
spam85930042sp_am
spang84919732sp_ang
spank115919572sp_ank
spans74528732sp_ans
spar65433302sp_ar
spas67036722sp_as
spat66548522sp_at
spawn107811712spawn
spay96631662sp_ay
spaz155626162sp_az
speaks125114582speaks
speaned103411522speaned
spears84019472spears
spec85821972spe_c
speck135115652speck
specs96916672specs
sped76031492spe_d
speed85526622speed
speel74420762speel
speer74623902speer
speil75618642speil
speir75315362speir
spelean937122spelean
spell75020302spell
spelt75430192spelt
spend85619332spend
spent75532832spent
sperm93216022sperm
spew95421872spe_w
spews105015922spews
spin66231302sp_in
splat76129342splat
splay105816042splay
spleen8310262spleen
spoon74719442spoon
sprag86418692sprag
sprain83614862sprain
sprang95713522sprang
sprat76635972sprat
spray106720062spray
spread9312532spread
spun66221462sp_un
spurn74815452spurn
stead65520272stead
steak95219802steak
steal56125472steal
steam76322932steam
stein54620542stein
stern55319122stern
swan76631312s_wan
swear85316852swear
sweat85628402sweat
wean75734352_wean
yean75834582_yean

Search took 4 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 Filter178691538000.313570897.8
2DLD Change Limit538001273.31016253.8
3Display Results1271270.0333848.5
 (SQL Overall)1786911273.65648876.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.