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 “bankerly” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
bankerly174433(None) 
angerly1137762_angerly
badgerly1543282badgerly
bakery155911002ba_ker_y
banker124222732banker__
bankers133919092banker_s
mannerly1344972mannerly
anergy10156863_an_ergy
backer144525523backer__
backers153821883backer_s
baker115629543ba_ker__
bakers125323453ba_ker_s
balker124519163balker__
balkers134915723balker_s
balkily16266693balk_ily
banally1249223ban_ally
bander93928223bander__
banderol1145853banderol
banderole1245143banderole
banderols1245953banderols
banders104324563bander_s
baneberry1642773baneberry
banger94423633banger__
bangers104020353banger_s
bankable1677913bankable
banked135021443banke__d
bankroll1443493bankroll
banner84421503banner__
bannered11299323bannered
banneret102412473banneret
bannerol1044313bannerol
bannerols1144093bannerols
banners94018713banner_s
banter84825333banter__
bantered113313633bantered
banterer102811773banterer
banters94623113banter_s
barberry1544853barberry
barely114716793ba_re_ly
barker124822863barker__
barkers134318513barker_s
barrenly1345413barrenly
basely114412313ba_se_ly
basketry1743513basketry
battery124911813batter_y
bayberry1842953bayberry
beanery1237563bean_er_y
bindery13459823binder_y
bitterly1335603bitterly
blanker134612023blanker__
blankly1634263blank__ly
bonkers134015303bonker_s
brokenly1744203brokenly
bunker124519373bunker__
bunkered15177183bunkered
bunkers133715953bunker_s
canker124422523canker__
cankered153010223cankered
cankers134418753canker_s
cannery123610003canner_y
danker114319663danker__
dankly14419463dank__ly
dapperly1643003dapperly
eagerly1136053ea_gerly
easterly11246643easterly
fakery16509263fa_ker_y
fatherly1745073fatherly
gingerly13315283gingerly
hanker134622093hanker__
hankered16289443hankered
hankerer15248233hankerer
hankers144218133hanker_s
innerly1037123_innerly
lanely93914483lan_e_ly
lanker104123003lanker__
lankily1437123lank_ily
lankly13439623lank__ly
latterly1136063latterly
lawyerly1742143lawyerly
markedly1843853markedly
masterly13317653masterly
monkery16317443monker_y
nakedly1534403na_kedly
painterly1443313painterly
ranker105021903ranker__
rankers113217463ranker_s
rankly133910453rank__ly
sanely93114613san_e_ly
sickerly1734023sickerly
tanker104521123tanker__
tankers113416913tanker_s
tannery10388653tanner_y
tenderly1245293tenderly
wanker134219973wanker__
wankers144514713wanker_s
winterly14306733winterly

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.1701051123.5
2DLD Change Limit146162967.76618820.8
3Display Results96960.0462087.0
 (SQL Overall)178691967.98222386.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.