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

114 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
backsaw183620(None) 
backsaws1946801backsaws
bucksaw1844371bucksaw
hacksaw1943711hacksaw
backs135729622backs__
backseat1648902backseat
backset15314192backset
backslap1844992backslap
backstab1845452backstab
backstay1945962backstay
bandsaw1334802bandsaw
bucksaws1943852bucksaws
hacksawn2042672hacksawn
hacksaws2043922hacksaws
jackdaw2442842jackdaw
baaskap1542513baaskap
babka137812913babk_a_
babkas146010143babk_as
babysat14135233babysat
bacalao1146613bacalao
bacca111012183bac_ca_
baccae12119703bac_cae
back125535763back___
backbeat1847843backbeat
backbit17129103backbit
backcast1887673backcast
backchat2147113backchat
backdate1748223backdate
backed155725723back_ed
backer144525523back_er
backers153821883backers
backfit18108213backfit
backflow2243373backflow
backhand2047433backhand
backhaul1945133backhaul
backhoe1847153backhoe
backing165523443backing
backland1748103backland
backlash1945923backlash
backlit15911903backlit
backload1746833backload
backlog1635773backlog
backout15612953backout
backpack1945463backpack
backseats1746673backseats
backsets1638853backsets
backside17108143backside
backslaps1945253backslaps
backslash2044543backslash
backslid1746273backslid
backspace2145083backspace
backspin1845423backspin
backstabs1945473backstabs
backstage1845423backstage
backstair1744683backstair
backstamp2144193backstamp
backstays2045653backstays
backstop1845563backstop
backup1646613back_up
backups1736173backups
backward2048103backward
backwash2244943backwash
backwrap2144073backwrap
backyard2046843backyard
bacula103112673bacula_
baklawa1643403ba_klawa
balks114926293balks__
balsa77920413ba_lsa_
balsam105612233ba_lsam
balsas86417523ba_lsas
bandsaws1444623bandsaws
banks115527903banks__
banksia1335943banksia
banksias1445893banksias
barks115735813barks__
basal75722283ba__sal
bashaw14349303ba_shaw
basks115621763basks__
becks135522013becks__
blackcap2043073blackcap
blacks144914953blacks__
bocks134526573bocks__
buckra1436753buckra_
buckram1746113buckram
buckras1537343buckras
bucks134824293bucks__
hackman1836433hackman
hacks144928713hacks__
hacksawed2243013hacksawed
handsaw1435533handsaw
hawkshaw2441963hawkshaw
jackal1937613jack_al
jackass2034963jackass
jackdaws2542923jackdaws
jacks185219833jacks__
jackstay2443133jackstay
jackstraw2552113jackstraw
kickshaw1942363kickshaw
lacks116129203lacks__
lockjaw2341823lockjaw
macaw12311763mac__aw
mackinaw1943103mackinaw
macks135127603macks__
packman1736693packman
packs135528933packs__
packsack1744523packsack
packwax2542853packwax
racks115028853racks__
rickshaw2042773rickshaw
sacks114228873sacks__
tacks115430133tacks__
wacks146626283wacks__
warsaw1236193wa_rsaw
yacks144419813yacks__

Search took 9 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 Limit1340271147.93616888.5
3Display Results1141140.0333454.5
 (SQL Overall)1786911148.12521992.7
 
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.