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

333 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
flauta93782(None) 
flautas1036151flautas
fauna84816512f_auna
flat77147822fla_t_
flats86429742fla_ts
flatus94310782flatus
flaunt9712912flaunt
flaunts1056132flaunts
flaunty1354412flaunty
flota85315642fl_ota
flout86226202flout_
flouts94315272flouts
flute86823752fl_ute
fluty114415642fl_uty
laura54116202_laura
valuta938742valuta
ablaut8313263ablaut_
ablauts936083ablauts
acta69524803__acta
alant55742293alant_
alants67722023alants
alaska1036713alaska
alate55340333ala_te
albata839333albata
alula5317093al_ula
anta46839583__anta
aura45836253__aura
auto47432083__auto
balata8614683balata
beaut75135213beaut_
beauts86015283beauts
beauty115410163beauty
bhakta1533653bhakta
blast76532573blast_
blasts85116773blasts
blasty115611053blasty
blat66550953bla_t_
blate75933783bla_te
blats75132503bla_ts
chaeta11310683chaeta
clapt98027173clapt_
clast76030583clast_
clasts84817293clasts
clausal936273clausal
clause84311503clause
claustra1043523claustra
clout75330463clout_
clouts87017203clouts
data56026653_da_ta
daut56443563_daut_
dauts67822243_dauts
elate55335883ela_te
eluate62315433eluate
elute54822573el_ute
exacta15337393exacta
facia103218463f_acia
fact97142543f_act_
facts107021893f_acts
facula112912233facula
faena85014203f_aena
faith115620853f_aith
fajita1635923fajita
fanga96119633f_anga
fart76860563f_art_
farts88336843f_arts
fast77052313f_ast_
fasts86429683f_asts
fat68178083f_a_t_
fatal84819373f_a_tal
fate75444283f_a_te
fats76252503f_a_ts
fatty115117413f_atty
fatwa1168063f_atwa
faucal11339963f_aucal
faugh125712963f_augh
fauld95214493f_auld
fault85428313f_ault
faults94513553f_aults
faulty12429363f_aulty
faun76226623f_au_n
faunae95210373f_aunae
faunal94711593f_aunal
faunas94013633f_aunas
fauns84516753f_auns
fauve114712073f_auve
faux146519073f_au_x
fava106820263f_a_va
fealty122910223fealty
feast85932723feast_
feasts95116093feasts
feat76458223fea_t_
feats86432753fea_ts
fecula113310053fecula
ferula93011173ferula
feta76528903f__eta
fiat76646643fia_t_
fiats85324483fia_ts
fibula11258053fibula
fiesta938123fiesta
filaria1039653filaria
flab96628353fla__b
flabby1634573flabby
flabs105818643fla_bs
flack144519413fla_ck
flacks154114533flacks
flacon1138633flacon
flag87427083fla__g
flaggy14415923flaggy
flagman13186173flagman
flagon1037983flagon
flags95321283fla_gs
flail85316183fla_il
flails94313003flails
flair86114123fla_ir
flairs95711913flairs
flak116026173fla__k
flake125119973fla_ke
flaked144715653flaked
flaker134916173flaker
flakes134118873flakes
flakey164410513flakey
flaky155715583fla_ky
flam96333293fla__m
flambe13489153flambe
flame105124443fla_me
flamed124618973flamed
flamen115215993flamen
flamer114919123flamer
flames114723693flames
flams105125013fla_ms
flamy135217473fla_my
flan76134183fla__n
flanes94522423flanes
flange103411973flange
flank124618093fla_nk
flanks133913403flanks
flans85327973fla_ns
flap96128703fla__p
flappy1654483flappy
flaps105621383fla_ps
flare84823633fla_re
flared105317603flared
flares94521703flares
flash115716213fla_sh
flashy15498173flashy
flask125512423fla_sk
flasks13488673flasks
flatcap1463653flatcap
flatcar1274613flatcar
flatly123110213flatly
flatted114012943flatted
flatten10429653flatten
flatter103815963flatter
flattop1244403flattop
flaunted1234603flaunted
flaunter1135013flaunter
flautist1186803flautist
flavin1239303flavin
flavor1236663flavor
flaw106326643fla__w
flawed134712723flawed
flaws115920343fla_ws
flawy145913383fla_wy
flax147325633fla__x
flaxen16518573flaxen
flaxes165015353flaxes
flaxy189012293fla_xy
flay106332803fla__y
flayed134414053flayed
flayer124713563flayer
flays116321053fla_ys
flea75628493fl__ea
fleet85932333fleet_
fleets96915063fleets
fleury12417353fleury
flint87333503flint_
flints95617453flints
flinty126112493flinty
flirt87424753flirt_
flirts95411483flirts
flirty12499143flirty
flit76539273fl_it_
flite85424963fl_ite
flits85625223fl_its
float85928573float_
floats96816253floats
floaty124210943floaty
flora85317103fl_ora
flotas94013003fl_otas
flour84916453flou_r
flours94414053flours
floury12449573floury
flouted113210813flouted
flouter104311343flouter
flu66530213fl_u__
flub95721883fl_u_b
flubs105515443fl_ubs
flue75329853fl_u_e
flued95021253fl_ued
flues84626923fl_ues
fluff103913613fl_uff
fluid94013963fl_uid
fluke125016893fl_uke
fluky154512293fl_uky
flume106021173fl_ume
flump124614723fl_ump
flung95114583fl_ung
flunk125014383fl_unk
fluor84512773fl_uor
flus75626543fl_u_s
flush115116073fl_ush
fluted104917163fl_uted
fluter95316863fl_uter
flutes95421783fl_utes
flutey125212523fl_utey
flux145617743fl_u_x
fluyt114614203fl_uyt
fluyts12367153fluyts
flyte115713943fl_yte
folate93320393fola_te
fractal1237623fractal
fracti1139963fracti
fraena938063fraena
frat75648543fra_t_
frats86829673fra_ts
fraud939863frau_d
frauds1036753frauds
frusta937453frusta
fusuma1134503fusuma
futz167823803f__utz
ghaut95919433ghaut_
ghauts10447783ghauts
glout65925813glout_
glouts74414713glouts
glut56331293gl_ut_
glute66020903gl_ute
gluts66120133gl_uts
halutz1868853halutz
haut75949733_haut_
haute89521613_haute
kata85626023_ka_ta
klutz1868853kl_utz
kraut95221403kraut_
krauts10418513krauts
labia75219013_labia
labra75415463_labra
lactam10310943_lactam
lacuna8118123_lacuna
laguna7127223_laguna
laith85722103_laith
laity85318903_laity
lama66635293_la_ma
lamia75324323_lamia
larva8312483_larva
last46260323_last_
lasts57731263_lasts
lat37593403_la_t_
late47560483_la_te
lath76640383_la_th
lati46438273_la_ti
lats45962703_la_ts
latte55426303_latte
latu47934183_la_tu
lauan55216793_lauan
laud56527723_lau_d
lauds65618483_lauds
laugh94414373_laugh
laurae64011663_laurae
lauras63414333_lauras
lava76725423_la_va
lepta75714393_lepta
likuta1034213likuta
llama799893lla_ma
lota47233503_l_ota
louma76213633_louma
lout45952143_lout_
louts56330273_louts
luma65527523_l_uma
luna46229853_l_una
lute46341013_l_ute
lutea54819073_l_utea
lutz136826323_l_utz
lytta888063_lytta
makuta1236393makuta
manta75629913_manta
maut65448453_maut_
mauts75927193_mauts
pasta76624533_pasta
plait75631573plait_
plaits83816473plaits
plant75437113plant_
plantar9369993plantar
plants84921803plants
planula935773planula
plasma103810913plasma
plat66048873pla_t_
platan83913693pla_tan
plate74635113pla_te
plats75531373pla_ts
platy105021663pla_ty
playa105812943pla_ya
plaza164311063pla_za
pleura837533pleura
pruta7314243_pruta
quanta153911333quanta
raita54623073_raita
reata54225393rea_ta
riata54618023ria_ta
salute64418023salute
sauna54117553_sauna
saute55028083_saute
scuta75815753_scuta
slant55238703slant_
slants64819083slants
slanty95114843slanty
slat46959023sla_t_
slate55438283sla_te
slats55436903sla_ts
slaty86523153sla_ty
sleuth937233sleuth
slut45040593sl_ut_
sluts54523983sl_uts
sputa74612963_sputa
taluka10426773taluka
taut47048963_taut_
tauts56125513_tauts
trauma838803trauma
ulama7711473ula_ma
umlaut838033umlaut_
umlauts943193umlauts
uta37425583___uta
valutas1036533valutas
yautia937253_yautia

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127163335.40320861.7
3Display Results3333330.0963468.8
 (SQL Overall)1786913335.89230327.7
 
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.