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

290 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
frusta93745(None) 
arista6415292arista
crista8311802crista
crust75827662crust_
crustal939022crustal
crusts84916542crusts
crusty114911342crusty
fiesta938122fiesta
frost84727832frost_
frosts94214622frosts
frosty124710632frosty
fruit85122222fruit_
fruits94512492fruits
fruity12429692fruity
frustum1243952frustum
fusty115016512f_usty
pruta7314242pru_ta
rust45544912_rust_
rusts55026992_rusts
rusty85221052_rusty
trust55426852trust_
trusts64714432trusts
trusty94710112trusty
adust64117453adust_
amusia839173amusia
aristae7312533aristae
aristas7413523aristas
aristo6414033aristo
barista9310813barista
bruit76126723bruit_
bruits85714453bruits
brunt75728753brunt_
brunts85215453brunts
brush105917473brus_h
brushy14468263brushy
brusk114912433brus_k
brut66537963bru_t_
brutal859383bru_tal
brute75321783bru_te
bruts75922953bru_ts
bursa74921523burs_a
burst75332243burst_
bursts85116243bursts
bust65947783_bust_
busts75227693_busts
busty105621013_busty
cesta75419483_cesta
costa75523733_costa
crest74632693crest_
crestal9312133crestal
crests85218703crests
crissa837623crissa
cristae9310613cristae
cruet74831843cruet_
cruets85314953cruets
crura7312583cru_ra
crus65828483crus__
cruse75726103crus_e
cruses88127713cruses
cruset84425093cruset
crusets93811043crusets
crush106815993crus_h
crusted103712753crusted
crystal1237433crystal
cuesta838513cuesta
curst74931023curst_
drest65530343drest_
druse64817663drus_e
druses75517253druses
durst66125173durst_
dust57142533_dust_
dusts65923563_dusts
dusty96018323_dusty
egesta7428653egesta
errata639013errata
erst47436433er_st_
eruct74022353eruct_
eructs83610793eructs
erupt74220063erupt_
erupts8348903erupts
fajita1635923fajita
fast77052313f_ast_
fasts86429683f_asts
fault85428313fault_
faults94513553faults
faulty12429363faulty
fauna84816513fau_na
feast85932723feast_
feasts95116093feasts
feist86230073feist_
feists94915313feists
feisty12449293feisty
fermata12278143fermata
ferula93011173feru_la
fest74949443f_est_
festal94213563f_estal
fests85828043f_ests
feta76528903f__eta
feus75830753feus__
fiestas1038433fiestas
first86226123first_
firsts95110923firsts
fist76248423f_ist_
fists85527543f_ists
flauta937823flauta
flota85315643f_lota
flus75626543flus__
flush115116073flus_h
fluster103913063fluster
flute86823753flu_te
fluty114415643flu_ty
fluyt114614203fluyt_
fluyts12367153fluyts
foist85730973foist_
foists95413983foists
forest94926743forest_
forestal11410283forestal
forestay1448193forestay
forests104114953forests
fossa85812633f_ossa
fount84727033fount_
founts94313383founts
fourth12357443fourth
fractal1237623fractal
fracti1139963fracti
fraena938063fraena
frass85321123fras_s
frat75648543fr_at_
frats86829673fr_ats
freesia1046323freesia
freest95318283freest_
frena85915273fr_ena
fresco1136473fresco
fresh115012203fres_h
fret75845043fr_et_
frets85523403fr_ets
fretsaw1343923fretsaw
fretty1249223fretty
frise85322453fris_e
frisee94217993frisee
frises94124273frises
frisk125312373fris_k
frisks13479263frisks
frisky16406673frisky
frit77044473fr_it_
frith115922033fr_ith
frits86129103fr_its
fritt86129413fr_itt
fritts94613193fritts
fritz176020773fr_itz
front85029223front_
frontal1038363frontal
fronts94415793fronts
frosh115713403fros_h
frosted113211873frosted
froth115919283fr_oth
frowst125512073frowst_
frowsts13426103frowsts
frowsty16464983frowsty
frug86517103fru__g
frugal1036393frugal
frugs96114283fru_gs
fruitage1244343fruitage
fruited11389093fruited
fruiter10309683fruiter
frump126912563fru_mp
frumps13479783frumps
frumpy16466883frumpy
frustrate1245583frustrate
frustule1154483frustule
frustums1342993frustums
furs76735043furs__
fuse76429993f_us_e
fused94820443f_used
fusee86224583f_usee
fusel85218493f_usel
fuses85628423f_uses
fusil84715323f_usil
fuss76027933f_us_s
fussy115613953f_ussy
fustian1036903f_ustian
fustic11910633f_ustic
fusuma1134503f_usuma
futz167823803f_u_tz
grist65529873grist_
grists74716483grists
grunt65523543grunt_
grunts75511853grunts
gust55240703_gust_
gusto65414643_gusto
gusts65722793_gusts
gusty95119573_gusty
gutta64613383_gutta
hosta85917833_hosta
hurst85527193hurst_
hursts97213093hursts
joust125122293joust_
jousts135011273jousts
junta123713673_junta
just115433343_just_
justs124918263_justs
kurta95113913_kurta
locusta9326533locusta
lust47442603_lust_
lustra6358893_lustra
lusts55022803_lusts
lusty85417573_lusty
musca9311763_musca
must65145443_must_
musth105314783_musth
musts75527443_musts
musty105620953_musty
nausea637313nausea
orisha936773orisha
oust46747443_oust_
ousts55225703_ousts
pasta76624533_pasta
presa74319043pres_a
prest75736353prest_
presto84216203presto
prests84021263prests
prost75434103prost_
prutah1136583pru_tah
quota145111963_quota
raita54623073_raita
reata54225393_reata
recta74220263_recta
resat55139683_resat
rest46459843_rest_
rests54935873_rests
rhyta1135083_rhyta
riata54618023_riata
ristra6310713_ristra
robusta944283robusta
rostra6310933_rostra
rota45834343_r_ota
roust55532063roust_
rousts617016723rousts
ruana5312423_ruana
ruga56121233_ru_ga
rumba93612513_rumba
runt46647993_runt_
runts55927633_runts
runty86119043_runty
ruse45938933_rus_e
ruses56136583_ruses
rush76628183_rus_h
rushy115414813_rushy
rusk85823313_rus_k
rusks95816193_rusks
rusted75020923_rusted
rustic8712673_rustic
rustle63615413_rustle
rut35560523_ru_t_
ruth76825993_ru_th
ruts44541493_ru_ts
rutty85617803_rutty
scuta75815753scu_ta
siesta639503siesta
sputa74612963spu_ta
sutta54015333_sutta
testa54822043_testa
thrust91911893thrust_
thrusts10226523thrusts
triste63818643triste
truest64816193truest_
truss54916923trus_s
trusted83412793trusted
trustee73514443trustee
truster73114313truster
trustor7238413trustor
truth85214153tru_th
tryst84716223tryst_
tryste9399583tryste
trysts9448793trysts
turista737443turista
ursa44116913ur_s_a
urus46426143urus__
uruses63616503uruses
uta37425583__u_ta
vesta86618303_vesta
vista85416603_vista
wrest84925433wrest_
wrests95313083wrests
wrist84827563wrist_
wrists95415643wrists
wristy12509703wristy
wurst85122993wurst_
wursts95211163wursts
yurta86014253_yurta

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.376475242.0
2DLD Change Limit1127162904.75023729.7
3Display Results2902900.0933118.3
 (SQL Overall)1786912905.21934238.6
 
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.