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

183 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
faciend133480(None) 
faciends1443571faciends
faced117727652fac_e_d
facies113921592facie_s
facing125321572faci_ng
fancied133310602fancie_d
fiend95312982f__iend
friend10388932f_riend
hacienda1442192hacienda
accent105116263_accent
aced79540883_ac_e_d
ached119227833_ache_d
achene11313813_achene
acid77533393_aci__d
acing87429153_aci_ng
acini75718983_aci_ni
acned87520663_acne_d
acred87126353_acre_d
acted88521733_acte_d
addend9458453_addend
affined1436413affined
afield1035953_afield
alien56425583_alien_
aliened81011743_aliened
aliens65619213_aliens
alined75221403_alined
amend85717753_a_mend
ancient9514733ancient
append1138273_append
ascend9429733_ascend
attend7258973_attend
augend837633_augend
babied114913513babie_d
bached145519893bache_d
backbend1944783backbend
backed155725723backe_d
bartend1038753bartend
basined10310003basined
cabined1239993cabined
cached145419203cache_d
calcined1338743calcined
caried94528693carie_d
fabled124216383fable_d
face96140123fac_e__
facer105525053fac_e_r
facers115519443fac_ers
faces106439433fac_e_s
facet106038523fac_e_t
facete115014833fac_ete
faceted13509563faceted
facets116316653fac_ets
faceup1334893fac_eup
facia103218463faci__a
faciae112913413faci_ae
facial113615633faci_al
facials123310743facials
facias113415803faci_as
facile112514883faci_le
facilely1644363facilely
facings134511263facings
faction122613333faction_
factions133013063factions
factoid1338693factoid
faded105025243fa_de_d
fadein1068843fadein_
fadeins1168503fadeins
fadged124712353fadge_d
fading114821113fadi_ng
faena85014203fa__ena
fagged124717703fagge_d
fagin9216573fagi_n_
fagins10513863fagi_ns
faience1237513fa_ience
failed105421603fa_iled
fain75840563fa_i_n_
fainer94717243fa_iner
faint85837063fa_i_nt
faired105915773fa_ired
faked135225483fa_ke_d
faking145520983faki_ng
fallen93813373fallen_
famed115928343fa_me_d
famine114318193fami_ne
famines123216263famines
faming124922973fami_ng
fancier123412063fancie_r
fanciers13358083fanciers
fancies124018783fancie_s
fanciest133612713fanciest
fanged114318223fange_d
fanion94514323fanion_
fanions103713073fanions
fanned104117473fanne_d
farced125216533farce_d
farcie114816473farcie__
farcies125317883farcie_s
farcing133514003farci_ng
farded114518953farde_d
fared95842343fa_re_d
farina94618233fari_na
faring105231283fari_ng
farmed125117653farme_d
farted105121783farte_d
fascine12510583fasci_ne
fascines13310143fascines
fashed136720253fashe_d
fasted105320953faste_d
fasten95114893fasten_
fastened12257853fastened
fastens105511753fastens
fated95632133fa_te_d
fathead1437863fathead
fating105328673fati_ng
fatted105419843fatte_d
fatten94314903fatten_
fattened12268283fattened
fattens105111713fattens
fawned134910423fawne_d
faxed166220533fa_xe_d
faxing175117053faxi_ng
fayed126422153fa_ye_d
faying134521073fayi_ng
fazed186222963fa_ze_d
fazenda2043253fa_zenda
fazing194418643fazi_ng
fecund1235433fec_und
fend84832973f___end
ficin103516723fici_n_
ficins113513983fici_ns
field95015323f__ield
fiends104110293f__iends
find87532603f__i_nd
fined94930503f__ined
flacked173711583flacke_d
flied96519433f_lie_d
foined105915013f_oined
forfend1435413forfend
fracted1339373fracte_d
fried95322913f_rie_d
friends11396743f_riends
fucked164114483fucke_d
gained84617463ga_ined
haciendas1542083haciendas
hacked164923513hacke_d
jacked204817523jacke_d
laced87132643lac_e_d
lacier84020093lacie_r
laciest93819033laciest
lacing94626233laci_ng
lacked135324653lacke_d
lagend838743la_gend
lazied164610653lazie_d
maced108528693mac_e_d
machined1637303machined
macing114221553maci_ng
macled116718113macle_d
nacred95212493nacre_d
paced106931683pac_e_d
pacier105018683pacie_r
paciest112917803paciest
pacing114522753paci_ng
packed154822603packe_d
pained95622853pa_ined
patient9617073patient
patined105114783patined
raced87635313rac_e_d
racier85120973racie_r
raciest92820013raciest
racing95030533raci_ng
racked134526083racke_d
rained75024603ra_ined
ravined115411823ravined
sacked135525213sacke_d
sacred94917103sacre_d
sained75424243sa_ined
salient7419763salient
sapiens9310173sapiens
sapient9415333sapient
scend85516293_sc_end
tacked134723943tacke_d
taxied14509373taxie_d
varied104817863varie_d
yacked164516793yacke_d

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.1401276364.3
2DLD Change Limit1340271837.20618599.4
3Display Results1831830.0603050.0
 (SQL Overall)1786911837.40624127.9
 
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.