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

61 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
bigfeet137615(None) 
bigfoot1355992bigfoot
biggest1138142biggest
aiglet74224193aig_let
aigret73720023aig_ret
baguet9316103bag_uet
beet66457543b___eet
befret11315963b_efret
beget85632553beg__et
beignet101510963beig_net
bidet84935623bi__det
biffed15449883bi_ffed
biffies152710853biffies
biflex1834953bi_flex
bigeye1236643big_eye
bigeyes1335653bigeyes
bigfoots1443633bigfoots
bigger104315063big_ger
biggety1434433biggety
biggie103810933biggie_
biggies113813523biggies
bighead14126653bighead
bight118728843big__ht
bighted142810923bighted
bigness1038193bigness
bigoses1039073bigoses
bigot84828323big__ot
bigoted11258403bigoted
bilgiest11309883bilgiest
billet86029723bi_llet
biofuel1243293biofuel
birdfeed1542443birdfeed
bisect10312873bi_sect
briefest1335893briefest
buffest15298633buffest
buffet143113783b_uffet
bugseed1136173bugseed
cigaret10413003cigaret
digest84019623dig_est
feet75352213___feet
figment1379743figment
giglet83920273gig_let
gleet65532343__gleet
greet65835323__greet
highest1439563highest
infect113413443_infect
infest93315433_infest
liefest1038443liefest
misfeed13389683misfeed
mismeet113215163mismeet
nighest11310693nighest
piglet93420923pig_let
pigment12510733pigment
pigweed1465093pigweed
regreet83015953regreet
rifest93114583ri_fest
signee73617233signee_
signees83510803signees
signet73621153sig_net
webfeet1544593webfeet
wiglet105519153wig_let

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.203880251.2
2DLD Change Limit134027618.54615683.0
3Display Results61610.0163812.5
 (SQL Overall)178691618.76520386.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.