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

112 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
phaseal124567(None) 
chasmal14158212chasmal
paleal84716672p_aleal
pascal10812372p_ascal
phase104617212phase__
phased124011972phase_d
phases114618402phase_s
phrasal1246162phras_al
aphasia122510873aphasia_
aphasiac15286593aphasiac
aphasias132710443aphasias
areal55928743__areal
asea46327183__asea_
basal75722283_bas_al
bharal1138893bha_ral
casual81112873_casual
chaetal1238283chaetal
chapeau1435523chapeau
chapel134911373chape_l
chase105127123chase__
chaseable1646343chaseable
chased125019293chase_d
chaser114918383chase_r
chasers123714923chasers
chases115128233chase_s
chateau1236273chateau
chiasmal15285033chiasmal
chisel112111943chise_l
choreal124412223choreal
coastal9411043coastal
easel54521113_ease_l
gharial1137343gharial
hadal95518123_ha_dal
haemal113811653_haemal
halal85623593_ha_lal
hallal94415563_hallal
hamal104623123_ha_mal
hammal134512073_hammal
hansel95214373_hanse_l
hartal9415483_hartal
hassel95614213_hassel
hazel176414813_haze_l
heal75645693_h__eal
hosel86024823_hose_l
miasmal1176743miasmal
nasal56217593_nas_al
nasial6413283_nasial
paean77222723p_a_ean
paesan85114093p_aesan
palea75028663p_alea_
paleae84820293p_aleae
palpal104112053p_alpal
panel76023623p_ane_l
papal95820673p_a_pal
parral85517543p_arral
pascals11610013p_ascals
paschal14157243p_aschal
pase65346863p_ase__
paseo77022513p_ase_o
paseos88015813p_aseos
pases75346503p_ase_s
pasha105417183p_asha_
pashas115117063p_ashas
passel85117003p_assel
pasta76624533p_asta_
pastas85422873p_astas
pastel85918713p_astel
pastil85018323p_astil
pausal81511963p_ausal
peal68648103p___eal
pease75231113pease__
peasen84815963pease_n
peases85229473pease_s
phage115113673phage__
phages125213513phage_s
phaseout1346783phaseout
phasic133612053phas_ic
phasing133211673phasing
phasis114614923phas_is
phasmid15267603phasmid
phial10313203ph__ial
phonal11310383ph_onal
phrase11109903phrase__
phrased1387383phrase_d
phrases12711463phrase_s
phratral1344373phratral
phreak1536153ph_reak
physed15386793physe_d
physeds16344033physeds
physes14399783physe_s
physical1845703physical
pineal84817693p_ineal
plagal948573pla_gal
plasma103810913plasma_
plasmas113010753plasmas
plastral1046913plastral
plateau937403plateau
postal84317533p_ostal
prase76128753prase__
prases84429023prase_s
premeal11310523premeal
presell939303presell
rascal8511123_rascal
reseal64819653_reseal
seal45654373___seal
sheal84927703sh__eal
teasel63914983tease_l
unseal63315473_unseal
vasal85516293_vas_al
vassal979243_vassal
weasel93410523wease_l
wheal115716183wh__eal

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.420425454.8
2DLD Change Limit1340271127.03319056.9
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.49923828.6
 
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.