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 “warfares” 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
warfares143668(None) 
carfares13310321carfares
warfare1336731warfare_
airfares1146692airfares
barwares13610092barwares
carfare12310072carfare_
fanfares1436772fanfares
warfarin1444982warfarin
warfarins1544732warfarins
warpages1437052warpages
wayfarer1742922wayfarer
wayfarers1842622wayfarers
welfares1445542welfares
wharfages1942632wharfages
workfares1943392workfares
afars85716513_a_far_s
affaires1444303_affaires
airfare1047243airfare_
arames84622573_ar_ames
arbores94016033_arbores
arcades101113193_arcades
armures9510273_armures
arrases71214543_arrases
barflies1338303barflies
barrages11711083barrages
barres84427543bar__res
barware12610703barware_
carafes125015703car_afes
carates95630613car_ates
carbarns1238563carbarns
carcases12313083carcases
carnages11312213carnages
cartages11313313cartages
catfaces1536963catfaces
caviares1337993caviares
curares94916853cur_ares
darbars10510093darbar_s
daycares1454803daycares
daymares1445333daymares
earmarks1444793earmarks
earwaxes1844703earwaxes
fanfare1336673fanfare_
fares85852873___fares
farfals13268503farfa_ls
furfures1445663furfures
garages9314113gar_ages
garbages1238183garbages
hardwares1646563hardwares
infares10313023_infares
karates115617473kar_ates
narrates8312763narrates
parades104121463par_ades
parbakes1638343parbakes
parfaits1346913parfaits
parkades1538273parkades
partakes1449923partakes
parures9512693par_ures
rares55247443__r_ares
safaris101110663sa_faris
sarapes94617743sar_apes
sardars83112903sardar_s
sarsars73512143sarsar_s
serfages1238233serfages
surfaces1338673surfaces
swarajes1843743swar_ajes
taffarel1442563taffarel
taffarels1541863taffarels
tarres64723043tar__res
tartare73012683tartare_
tartars73313403tartar_s
urares64519093_ur_ares
variates111214983variates
wafered14288433wa_fered
wafers124316143wa_fer_s
waffies163611443wa_ffies
wafflers17306323wafflers
waffles16329983wa_ffles
waftages15105393waftages
wafters134112813wa_fters
waftures1434853waftures
wakames1635283wa_kames
wannabes1344473wannabes
wantages12109023wantages
warblers13319103warblers
warbles123215563war_bles
warders113416813warder_s
wardress12256163war_dress
wares88250583w___ares
warhorse1445343warhorse
warhorses1545573warhorses
warlords1245303warlords
warmaker1735973warmaker
warmakers1845633warmakers
warmers124514293warmer_s
warners103315563warner_s
warpage1336403warpage_
warpaths1643973warpaths
warpers123413583warper_s
warplanes1445893warplanes
warrants1168503warrants
warred104019843war__red
warren95012853war__ren
warrens103810893war__rens
warsaws1335763warsa_ws
warslers11328073warslers
warsles103413643war_sles
warstles11368803warstles
wartimes1336963wartimes
warworks1877063warworks
wastages12109753wastages
watapes12228383wa_tapes
wattages12106783wattages
wattapes1395253wattapes
welfare1335713welfare_
wetwares1445953wetwares
wharfage1842213wharfage_
wordages1337053wordages
workfare1843123workfare_
yardages1336203yardages
yardarms14123333yardarms
zaffars22325233zaffar_s
zaffres22324993za_ffres

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621227.36019859.0
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.56223630.1
 
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.