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

204 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
fauns8451675(None) 
fans76247371fa_ns
faun76226621faun_
fauna84816511fauna
faunas94013631faunas
fawns115914261fawns
funs75235731f_uns
ains46158882_ains
anus47131112_anus
auks85525262_auks
aunt46553652_aunt
aunts55227632_aunts
awns75324432_awns
banns75321232banns
bans66555142ba_ns
barns76335142barns
bauds85821042bauds
buns66243722_buns
cains75334302cains
cans65050852ca_ns
carns75937562carns
cauls75727772cauls
damns84916922damns
dans56748152da_ns
darns66927892darns
daubs85014562daubs
daunt65929082daunt
daunts75014082daunts
dauts67822242dauts
dawns95916592dawns
duns55140432_duns
earns55927562earns
fabs98635862fa_bs
faces106439432faces
facts107021892facts
fades94932862fades
fados95620732fados
fads86939872fa_ds
faena85014202faena
faenas94412762faenas
fagins10513862fagins
fags86939122fa_gs
fails85631482fails
fain75840562fain_
faint85837062faint
faints94818782faints
fairs85825442fairs
fakes126032482fakes
falls85727652falls
fames105735922fames
fan67158862fa_n_
fane75343572fa_ne
fanes84639892fanes
fang85432552fa_ng
fangs96224072fangs
fanny114816042fanny
fano75831692fa_no
fanons96115212fanons
fanos85926502fanos
fanum10313442fanum
fanums1137262fanums
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
fas68262932fa__s
fasts86429682fasts
fates85139232fates
fats76252502fa_ts
fauces114916152fauces
faugh125712962faugh
fauld95214492fauld
faulds10438962faulds
fault85428312fault
faults94513552faults
faunae95210372faunae
faunal94711592faunal
fauve114712072fauve
fauves125610422fauves
faux146519072fau_x
favas115618592favas
faves115331422faves
favus114311732favus
fawn105321952fawn_
fawny144711712fawny
faxes155726652faxes
fays108535362fa_ys
fazes175527212fazes
fens76139762f_ens
ferns85220082ferns
feuds95914882feuds
feus75830752feu_s
fins75849092f_ins
firns86018542firns
flans85327972flans
flaunt9712912flaunt
flaunts1056132flaunts
flubs105515442flubs
flues84626922flues
flung95114582flung
flunk125014382flunk
flunks13469862flunks
flus75626542flu_s
fohns117310782fohns
foins85523382foins
fons76943892f_ons
fouls87221432fouls
found94917842found
founds104814192founds
fount84727032fount
founts94313382founts
fours85521492fours
frauds1036752frauds
frons86124042frons
frugs96114282frugs
fubs96328792f_ubs
fuds86528562f_uds
fugs85730692f_ugs
fun66841142f_un_
fund85624982f_und
funds94119252f_unds
funk115825622f_unk
funks125318912f_unks
furs76735042f_urs
fuss76027932f_uss
gains65729512gains
gauds75717722gauds
gaums86217072gaums
gaun56427712gaun_
gaunt65430402gaunt
gaurs66317992gaurs
gauss65613452gauss
guans64419442guans
guns55533482_guns
hauls86123732hauls
haunt85229132haunt
haunts95614392haunts
huns76136932_huns
jauks165412462jauks
jaunt125025272jaunt
jaunts137511882jaunts
jaups144810532jaups
kains96125642kains
kaons95014852kaons
karns96624142karns
lauans65113532lauans
lauds65618482lauds
lawns85215422lawns
mains75635112mains
mans66354552ma_ns
manus75924932manus
mauds85519272mauds
mauls76524952mauls
maun65727212maun_
maund85515452maund
maunds9519652maunds
mauts75927192mauts
muns65535922_muns
naans55815252naans
nans46139402na_ns
nouns56717312nouns
nuns45228232_nuns
pains75138282pains
pans65855732pa_ns
pawns108818132pawns
puns66641482_puns
rains55140232rains
runs46438082_runs
sains55639972sains
sans45153362sa_ns
sauls55128122sauls
sauna54117552sauna
saunas63915432saunas
shuns85018142shuns
stuns54719492stuns
suns45841902_suns
tabuns8489222tabuns
tains54936322tains
tans46154822ta_ns
tarns56433952tarns
taunt55532282taunt
taunts65715662taunts
tauons63412672tauons
taus46342732tau_s
tauts56125512tauts
tuns45138662_tuns
uns35936762__uns
vans76236732va_ns
vaunt85925312vaunt
vaunts95212622vaunts
vaus75928922vau_s
wains86930872wains
wans76452272wa_ns
warns87231002warns
wauks125515162wauks
wauls86120552wauls
yamuns11336512yamuns
yarns85621792yarns
yauds95013222yauds
yaups105910742yaups
yawns114213272yawns
yuans84613322yuans

Search took 2 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.330541487.9
2DLD Change Limit538002041.40638264.6
3Display Results2042040.0464434.8
 (SQL Overall)1786912041.782100275.5
 
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.