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

104 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
welfare133571(None) 
welfares1445541welfares
warfare1336732warfare
wetware1335792wetware
aglare7312423agl_are
airfare1047243airfare
before11410153be_fore
beldame1237233beldame
belfry1435073belf_ry
beware11313713be_ware
blare75826233_bl_are
carfare12310073carfare
cellae84915933cella_e
cellar84514983cellar_
cellared11398793cellared
cellarer10317923cellarer
cellaret103713573cellaret
cellars93713693cellars
centare93113703centare
decare93919153de_care
deciare10710663deciare
declare10411223declare
deface123113863de_face
defame123212433de_fame
deflate113613943deflate
dekare112811563de_kare
delate73827753del_ate
deleave1147723deleave
delftware1651483delftware
efface14366673_efface
elate55335883_el_ate
eluate62315433_eluate
enface112510353_enface
fanfare1336673fanfare
fare76354463___fare
fellate10313433fellate
fieldfare1651453fieldfare
flare84823633_fl_are
gelate73421253gel_ate
glare65222953_gl_are
hectare1238463hectare
hektare1435503hektare
hellfire1464263hellfire
infare9313083_infare
leafage1194573leafage
meltage1037953meltage
pelage9515363pel_age
peltate92013773peltate
redware1139353redware
reface113616353re_face
refire95419473re_fire
reflate103516263reflate
relace83122153rel_ace
relate64033633rel_ate
relearn747973relearn
release7312763release
seafarer1144843seafarer
seaware1049623seaware
selfsame1342883selfsame
selfward1543093selfward
selvage1136553selvage
serfage1138403serfage
sulfate10311653sulfate
teaware1048143teaware
telae54323293tel_a_e
telfer9379893telfer_
telfered1234883telfered
telfers10299073telfers
telford1145153telford
velar85817633vel_ar_
velars93913723vel_ars
velate93720143vel_ate
velure939773vel_ure
ware76254723w___are
warfares1436683warfares
wayfarer1742923wayfarer
wear75836723we__ar_
wearer94319403we__arer
wears86030303we__ars
weary115620613we__ary
weave115218533we__ave
webpage1543133webpage
welcher15319393welcher
welcome1445193welcome
weldable1436863weldable
welder102914413welder_
welders113313413welders
weldor10317653weldor_
weldors11238003weldors
welfarism1753083welfarism
welfarist1544833welfarist
wellie92814913wel_lie
welsher13377443welsher
welter93417383welter_
weltered12238433weltered
welters103516063welters
were76238333we___re
wetwares1445953wetwares
wheyface2261553wheyface
wildfire1542803wildfire
wolfer12429983wolfer_
wolfers13409633wolfers
wolfram1543113wolfram
workfare1843123workfare

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271047.48317910.9
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.68523251.9
 
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.