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

128 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
phase10461721(None) 
chase105127121chase
pase65346861p_ase
pease75231111pease
phage115113671phage
phased124011971phased
phases114618401phases
phrase11109901phrase
prase76128751prase
abase76023482abase
base64847022_base
blase75524232blase
case65848082_case
cease75227652cease
chafe135117352chafe
chaise114916412chaise
chape125221142chape
chare105231982chare
chased125019292chased
chaser114918382chaser
chases115128232chases
chasm125518792chasm
chasse115114602chasse
chaste114617392chaste
chose105925402chose
diphase1387272diphase
ease45042332_ease
ephas10311542ephas_
erase54925492erase
fease84824872fease
ghast95621222ghast
hade85440192_hade
hae67364002_ha_e
haes77651022_haes
hake115637842_hake
hale76052832_hale
hame97043132_hame
hanse85722792_hanse
hare76255732_hare
has67372652_has_
hash106936502_hash
hasp96627292_hasp
hast76259482_hast
haste85927862_haste
hate78450172_hate
have106137072_have
hawse116015122_hawse
haze164833392_haze
hose76547242_hose
inphase1245382inphase
lase46148512_lase
lease55230262lease
lyase85512412lyase
pace86345772p_ace
page76036102p_age
paise75028332paise
pale66055012p_ale
pane64950282p_ane
pare66760842p_are
parse75236992parse
pas58775742p_as_
paseo77022512p_aseo
pases75346502p_ases
pash95638132p_ash
pass65239952p_ass
passe75525692passe
past65959012p_ast
paste74932952p_aste
pate65350462p_ate
pause75021832pause
pave96133892p_ave
peace95026082peace
peage84723562peage
peas65755062peas_
peasen84815962peasen
peases85229472peases
peise75825772peise
perse75429522perse
phages125213512phages
phaseal1245672phaseal
phasic133612052phasic
phasis114614922phasis
phat95837862pha_t
phis95724902phis_
phone105621932phone
phrased1387382phrased
phrases12711462phrases
phyle134111152phyle
physed15386792physed
physes14399782physes
pias66542552pias_
place94824612place
plage84520402plage
plane74929142plane
plash104616562plash
plasm94114632plasm
plate74635112plate
please84315732please
poise75127892poise
pose66441732p_ose
posse74722272posse
praise84419412praise
prases84429022prases
prate75135982prate
prese75228382prese
prise74632612prise
prose75835122prose
pulse74219972pulse
purse76028892purse
pyas96225702pyas_
rase46149982_rase
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shave114425892shave
tease55428712tease
thae76825562tha_e
thane86122532thane
these86519012these
those85218142those
ukase9428492ukase
urase54624682urase
vase75629652_vase
whale115517432whale
whose114914532whose

Search took 3 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.0901985455.6
2DLD Change Limit538001282.00326859.7
3Display Results1281280.0761684.2
 (SQL Overall)1786911282.16982384.0
 
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.