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

122 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
fiasco1110492(None) 
fiascos12124741fiascos
cisco95112132ci_sco
disco85616072di_sco
fiance11310742fiance
fiaschi1542792fiaschi
fiascoes13134922fiascoes
fico95824592fi__co
fisc96819752fi_sc_
fiscs105311882fi_scs
fresco1136472fresco
pisco96314982pi_sco
arco68331543__arco
asci66519143__asci
ascot76522513__ascot
banco94019393_banco
basso76017283_basso
bias64738163bias__
biased94012223biased
biases84618433biases
ciao64924183cia__o
ciscos104711133ci_scos
diazo15310033dia_zo
dipso85111553dips_o
disc76123233di_sc_
disci85815023di_sci
discos94915213di_scos
discs85316263di_scs
face96140123f_a_ce
fact97142543f_a_ct
fado87226463f_a_do
falcon11310293f_alcon
fancy134615483f_ancy
fano75831693f_a_no
farce104925323f_arce
farci105919313f_arci
farcy135217093f_arcy
faro76136923f_a_ro
fas68262933f_as__
fasces114914543f_asces
fascia1148703f_ascia
fash107232293f_as_h
fast77052313f_as_t
fasts86429683f_asts
fatso85113493f_atso
fease84824873feas_e
feased105718713feased
feases95422923feases
feast85932723feas_t
feasts95116093feasts
fiacre1137623fiacre
fiancee1238953fiancee
fiances12310673fiances
fiar76427333fia__r
fiars86720833fia_rs
fiat76646643fia__t
fiats85324483fia_ts
fibs96329503fibs__
fice95737113fi__ce
fido87726403fi__do
fids87034743fids__
fierce11348913fierce
fiesta938123fiesta
figs85332643figs__
filch134813323fi_lch
fillo84319783fi_llo
filo76034283fi__lo
fils75838693fils__
finance1238573finance
finca104714503fi_nca
finch135416973fi_nch
finito9310303finito
fino76034693fi__no
fins75849093fins__
firs76637713firs__
first86226123firs_t
firsts95110923firsts
fiscal1139333fi_scal
fish106926273fi_s_h
fishy146011663fi_shy
fission1038733fission
fist76248423fi_s_t
fists85527543fi_sts
fitch134816873fi_tch
fits76043463fits__
flack144519413fla_ck
flacon1138633fla_con
flash115716213flas_h
flashy15498173flashy
flask125512423flas_k
flasks13488673flasks
flysch1732893flysch
franc104615413franc_
francs114112193francs
frass85321123fras_s
frescos1236813frescos
gascon9339723_gascon
gismo848863gi_smo
guaco85012163gua_co
jiao115017843jia__o
kirsch1532713kirsch
kitsch1533353kitsch
lasso55015683_lasso
mascon103612743_mascon
mascot104016073_mascot
miasm91211093mias_m
miasma1097563miasma
miasms1097383miasms
misact10316683misact
misdo85413183mi_sdo
miso67229903mi_s_o
narco76718243_narco
paseo77022513_paseo
peascod1244073peascod
piano76118713pia_no
pias66542553pias__
piscos105112593pi_scos
piso66727563pi_s_o
rialto638603rialto
rias45540593rias__
taco67031353_ta_co
wilco1039443wi_lco

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 Limit1127161224.96622697.5
3Display Results1221220.0333697.0
 (SQL Overall)1786911225.37533244.8
 
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.