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

293 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
friends1139674(None) 
fiends104110291f_iends
friend10388931friend_
befriends1542412befriends
faciends1443572faciends
fends96324972f__ends
fields104211042f_ields
fiend95312982f_iend_
finds95424822f_i_nds
forfends1544832forfends
fried95322912frie_d_
friended1335032friended
friendly1544372friendly
friers94718932frie_rs
fries85535602frie__s
friezes19418912friezes
fronds106412342fr_onds
grinds84511842gri_nds
orients7311582orients
rends65129952_r_ends
rinds64826142_ri_nds
trends75513542tr_ends
trienes74118412trienes
triens65417542trien_s
addends10356053addends
aliens65619213alien_s
amends94713283_amends
appends1236393appends
arenas65021993ar_enas
arenes64928393ar_enes
argents84014853argents
ariels65119373arie_ls
arpens84814823arpen_s
arpents93613083arpents
ascends10388203ascends
attends8257593attends
augends935883augends
bartends1136793bartends
befriend1443263befriend_
bends85628973__bends
bields94110003_bields
binds86627473_bi_nds
blends96012883_blends
blinds95111613bli_nds
boyfriends195623boyfriends
brands95118943br_ands
breads95419203br_eads
breeds94914883br_eeds
brens75823363br_en_s
brents84717273br_ents
briards10398553briards
briefs115510073brie_fs
briers85319733brie_rs
bries74942153brie__s
brigands1245623brigands
brined95118413brined_
briners94315633briners
brines85028853bri_nes
brings94618433bri_ngs
brinks124616313bri_nks
brins75533973bri_n_s
calends1039523calends
chields13507483chields
clients938093clients
creds85418773cr_e_ds
creeds94714773cr_eeds
cried84624283crie_d_
criers83918583crie_rs
cries75438403crie__s
defends12358773defends
depends11348993depends
dienes75719903_dienes
dreads84115023dr_eads
dried75321383drie_d_
driers74516733drie_rs
dries64733673drie__s
drinks116810713dri_nks
drownds12346153drownds
emends95711433_emends
ends56528523___ends
errands847583errands
expends17217083expends
extends15227113extends
faciend1334803faciend_
faenas94412763f_aenas
faience1237513faience
faiences1337043faiences
faints94818783fai_nts
farinas103215233fari_nas
fazenda2043253fazenda
fazendas2143073fazendas
feds85234313f__e_ds
feeds94921143f__eeds
feigns10407753feign_s
feints94813873fei_nts
fend84832973f__end_
fens76139763f__en_s
feods99516853f__eods
ferments13311473ferments
feuds95914883f__euds
fids87034733f_i__ds
fiefs116213703f_ie_fs
field95015323f_ield_
fiendish1544033f_iendish
find87532603f_i_nd_
fined94930503f_ined_
fines86644263f_i_nes
finis86824263f_i_nis
finks125424223f_i_nks
finos86226953f_i_nos
fins75849093f_i_n_s
fiords10498623f_iords
fired94829743fire_d_
firers94922683fire_rs
fires85740753fire__s
firings114112323firings
firns86018543f_irn_s
fjelds17414473f_jelds
flied96519433flie_d_
fliers94417193flie_rs
flies85630713flie__s
flings106715283fli_ngs
flints95617453fli_nts
foined105915013foined_
foins85523383foi_n_s
foments122912053foments
fonds95824823f__onds
forefends1644493forefends
forfend1435413forfend_
forints10411833fori_nts
founds104814193f_ounds
fraena938063fraen_a
fraenum1255703fraenum
fraenums1353403fraenums
francs114112193fr_ancs
franks134912733fr_anks
frauds1036753fr_auds
freaks134713063fr_eaks
freed95223543fr_eed_
freeness11710443freeness
freers94717303fr_eers
frees86131393fr_e_es
freezes193310353freezes
fremd115010323fr_emd_
frena85915273fr_en_a
french143511213fr_ench
frenum1188803fr_enum
frenums1236203fr_enums
frenzy2135883fr_enzy
freres94716173fr_eres
frets85523403fr_e_ts
friars93812093fri_ars
fricando1443213fricando
fridges12369483fridges
friending1495553friending
friendless1442543friendless
friendlies1442933friendlies
friendship1952213friendship
frier85225843frie__r
frieze18378143frie_ze
friges104116483fri_ges
frights14339623frights
frigid1136923frigid_
frigs96019273fri__gs
frills94414223fri_lls
fringe104013953fri_nge
fringes113514103fringes
fringy13309263fri_ngy
frisees104411693frisees
frises94124273fri_ses
friseurs1133303friseurs
frisks13479263fri_sks
frites94922483fri_tes
friths124313583fri_ths
frits86129103fri__ts
fritts94613193fri_tts
fritzes19329453fritzes
frivols1334743frivols
frized193510683frized_
frizers19329553frizers
frizes184015463fri_zes
frizzes18338183frizzes
froes86126693froe__s
frond95316343fr_ond_
frons86124043fr_on_s
fronts94415793fr_onts
frowns126011393frown_s
fryers125710973frye_rs
funds94119253f__unds
furies95126373furie__s
grands84218243gr_ands
greeds84314283gr_eeds
greens75716873green_s
grids75321393gri__ds
griefs10418723grie_fs
grieves1137323grieves
grind75917563gri_nd_
grins65427223gri_n_s
grounds9228303grounds
hinds96721473_hi_nds
impends12376803impends
intends8239963intends
irids66417763iri__ds
kalends1235683kalends
kinds106221813_ki_nds
lagends947273lagends
legends936073legends
lends65326253__lends
liens56525503_lien_s
mends84927693__mends
miens76118303_mien_s
minds85427123_mi_nds
offends14234293offends
oreads73915773or_eads
oriels64914623orie_ls
orient6322533orien_t
pends85527193__pends
perpends13227733perpends
poinds93511143poi_nds
portends11358963portends
prebends13347883prebends
preens85020113preen_s
pretends11299113pretends
pried84426863prie_d_
priers84521193prie_rs
pries74339533prie__s
priests93810863priests
prinks124315383pri_nks
prints84320103pri_nts
prions84317783prion_s
propends13249173propends
protends113010353protends
rands65930453_r_ands
reads64835273_r_eads
redds74617833_r_edds
reds56042863_r_e_ds
reeds65430903_r_eeds
reinks105012153_reinks
reins56234563_rein_s
relends84013253relends
remends105013033remends
rend56136573_r_end_
rents55935183_r_ents
resends83513713resends
ribands10208393_ribands
rids56539543_ri__ds
riels55121333_rie_ls
rind56535603_ri_nd_
rindy95717393_ri_ndy
rings65029173_ri_ngs
rinks94827103_ri_nks
rins46153193_ri_n_s
ripens85012173_ripen_s
rounds73615613_rounds
rynds9569973_r_ynds
scends95213003_scends
sends65528243__sends
shends105313773_shends
shields11538043shields
sirens65318153siren_s
spends94714473_spends
stipends11304793stipends
teinds738263tei_nds
tends65425583__tends
treads74817913tr_eads
treens65317873treen_s
trend64817453tr_end_
trendy10469603tr_endy
triads74513523tri_ads
tridents938583tridents
tried65026913trie_d_
triene64316383trien_e
trientes82812123trientes
triers64321523trie_rs
tries55742813trie__s
trined74920713trined_
trines64132563tri_nes
tripods10359053tripods
triunes74311383triunes
unbends10236993unbends
upends9438763_upends
upsends10265293upsends
urines64724123uri_nes
vends95520893__vends
viands1047813_viands
wends95822813__wends
wields10469623_wields
winds95425603_wi_nds
wrens85016243wr_en_s
wried95518563wrie_d_
wries85827743wrie__s
wrings104012973wri_ngs
yields10466843_yields

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.1561145455.1
2DLD Change Limit1340272936.90619407.3
3Display Results2932930.0933150.5
 (SQL Overall)1786912937.15524974.3
 
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.