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

298 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
warsaw123619(None) 
warsaws1335761warsaws
sarsar63011842sarsar
tarsal63315272tarsal
wars78659802wars__
warsle93112922warsle
ansa45927773_ansa_
ansae55720973_ansae
arak86929573_ar_ak
area45843393_area_
areae55229743_areae
areal55928733_areal
areas55935773_areas
argal65023383_argal
arhat8327093_arhat
aria46245423_aria_
arias55438023_arias
arras55626133_arras
array86317143_array
arrow83414883_arrow
ars37670933_ars__
arse46539273_ars_e
arses55733873_arses
arsis55722423_arsis
arson55118833_arson
artal55525473_artal
arval86017013_arval
assai5711543_assai
assay8710283_assay
backsaw1836203backsaw
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
bandsaw1334803bandsaw
barbal104016663barbal
barca91319433barca_
barcas101016603barcas
barlow112911423barlow
barman103519703barman
barrow114512763barrow
bars66564093bars__
basal75722283ba_sal
bashaw14349303bashaw
braw94829563_br_aw
bursa74921523bursa_
bursae84515603bursae
bursal84414823bursal
bursar85413253bursar
bursas85318273bursas
caesar8410933caesar
carat75048793car_at
carman103920743carman
carnal83919203carnal
carpal103716253carpal
cars67364763cars__
carse74934333cars_e
carses85233653carses
casa65630863ca_sa_
casas75327843ca_sas
cashaw14439793cashaw
catspaw1443353catspaw
causal81413203causal
corsac10410173corsac
craw97725263_cr_aw
darbar959953darbar
daresay1135433daresay
darshan1167063darshan
dorsa64617283dorsa_
dorsad8408973dorsad
dorsal74613943dorsal
draw85623013_dr_aw
earlap837183earlap
ears46356593ears__
earwax1664733earwax
farad95720673far_ad
farfal123410183farfal
farrow12309973farrow
foresaw1377133foresaw
garda7316763garda_
gardai839663gardai
gars55750743gars__
hacksaw1943713hacksaw
handsaw1435533handsaw
hansa85416783hansa_
hansas94616043hansas
harass9313943harass
harrow122610773harrow
harsh116418053hars_h
hartal9415473hartal
hearsay1335523hearsay
jarrah1636683jarrah
jars117338353jars__
jigsaw1742493jigsaw
karat96837593kar_at
karma113415003karma_
karmas123013733karmas
karst97228993kars_t
karsts106012943karsts
lariat6629043lariat
lars46956573lars__
larva8312483larva_
larvae938843larvae
larval948503larval
larvas9310233larvas
macaw12311763ma_caw
mara67444563mar_a_
maras75443283mar_as
margay12310593margay
maria75032883maria_
marka114620793marka_
markas124717003markas
marram10313883marram
marrow112812603marrow
mars66261863mars__
marsala939583marsala
marse76231153mars_e
marses84827113marses
marsh105320853mars_h
marshal1238973marshal
marshy14558333marshy
masa65034713ma_sa_
masas75630413ma_sas
massa75518923massa_
massas85116463massas
matsah1138233matsah
narial6317953narial
narrow9269143narrow
narwal938943narwal
nasal56217593na_sal
naysay1234973naysay
oars46846033oars__
oarsman937733oarsman
outsaw92610283outsaw
oversaw13268163oversaw
paesan85114093paesan
paisa76021073paisa_
paisan84417073paisan
paisas84317493paisas
papaw125112493pa_paw
para65242173par_a_
parae76335703par_ae
paras76143043par_as
pardah123412823pardah
pariah114320583pariah
parian83223963parian
parka115120883parka_
parkas125018023parkas
parlay113713993parlay
parral85517533parral
pars67560793pars__
parse75236993pars_e
parsec105914473parsec
parsed96323893parsed
parser84822373parser
parses85534703parses
parson83817903parson
partan83820563partan
pausal81511963pausal
pawpaw1653503pawpaw
pitsaw1135613pitsaw
raw67252253__r_aw
resaw84117253_resaw
ripsaw1134283ripsaw
salsa56718923salsa_
salsas65316133salsas
sansar63613393sansar
saran53730303sar_an
sardar73013173sardar
sarsars73512143sarsars
sarsen6314233sarsen
saw68255353___saw
seesaw935973seesaw
straw813321293str_aw
swaraj1636023swar_aj
tarmac10310333tarmac
tarnal63716503tarnal
tarpan82814293tarpan
tars46763953tars__
tarsals72512603tarsals
tarsi55222173tars_i
tarsia65514273tarsia
tarsias74013373tarsias
tarsus6310513tarsus
tartan64217513tartan
tartar63214753tartar
tarzan152910753tarzan
thraw1110515923thr_aw
ursa44116903_ursa_
ursae55214453_ursae
vara75530883var_a_
varas86028193var_as
varia85824203varia_
varias95019903varias
varna84516173varna_
varnas94212823varnas
vars75742073vars__
vasa76522973va_sa_
vasal85516293va_sal
vassal979243vassal
versal93013753versal
wabs97337233wabs__
wadmal1237283wadmal
wads87343143wads__
wadset10314303wadset
waes76048603waes__
wags86140553wags__
wairs86424063wairs__
waist86132383wais_t
waists97415453waists
walla85321033walla_
wallah124011993wallah
wallas95719393wallas
wallow123913513wallow
wangan10311223wangan
wans76452263wans__
waps96642083waps__
war67262423war___
warble113516603warble
ward86542253war__d
warded115021043warded
warden104515513warden
warder104020273warder
wards97734403war_ds
ware76254723war__e
wared96339873war_ed
wares88250583war_es
warfare1336733warfare
warhead1436603warhead
warier93722893warier
warily122915093warily
waring105029443waring
warison1037083warison
wark115737773war__k
warked144421213warked
warks127932403war_ks
warm95935673war__m
warmed124516893warmed
warmer113816733warmer
warmly14228063warmly
warms107726853war_ms
warmth1477933warmth
warmup1335343warmup
warn75239323war__n
warned104018913warned
warner93717223warner
warns87231003war_ns
warp95635003war__p
warpage1336403warpage
warpath1545203warpath
warped124816413warped
warper114015583warper
warps107126423war_ps
warrant10614243warrant
warred104019843warred
warren95012853warren
warship1547833warship
warsled112910443warsled
warsler10289893warsler
warsles103413643warsles
warstle10328013warstle
wart77866083war__t
warted104223233warted
warts814840403war_ts
warty119323823war_ty
wary106740013war__y
was68767563wa_s__
wasabi1154643wa_sabi
wash106033813wa_s_h
washy145911843wa_shy
wasp95626853wa_s_p
wasps106714693wa_sps
waspy135410993wa_spy
wassail1056133wassail
wast75655853wa_s_t
waste86125053wa_ste
wasts87433673wa_sts
watap102111673wa_tap
wats77555883wats__
waw97046383w___aw
waws106834903waws__
waylay1535453waylay
ways107737953ways__
wears86030303wears__
whipsaw1842723whipsaw
wirra83210823wirra_
worse86525263wors_e
worsen95513873worsen
worser95117523worser
worses95522953worses
worset96726583worset
worst86330133wors_t
worsts96014333worsts
wrap96821973w_r_ap
wrasse9398773wrasse
wreak125513273w_reak
wurst85122993wurs_t
wursts95211163wursts
yarrow12287933yarrow

Search took 7 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.1401276364.3
2DLD Change Limit1127162985.83019333.8
3Display Results2982980.0933204.3
 (SQL Overall)1786912986.06329472.4
 
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.