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

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

58 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
runlet6382141(None) 
rundlet83114151rundlet
runlets73310771runlets
unlet54133331_unlet
auklet104216832auklet
brunet84419292brun_et
bullet84528612bullet
culet76040342cu_let
cullet84727312cullet
cutlet84924362cutlet
guglet84018222guglet
gullet74924832gullet
inlet53732402_inlet
junket173815022junket
lunet56835422lun_et
mullet84126822mullet
nutlet64220562nutlet
outlet63728682outlet
pullet84026332pullet
punnet83518842punnet
reflet94024232reflet
reglet73724232reglet
relet54749822r_elet
rennet64624852rennet
riblet84222442riblet
rillet64828852rillet
ringlet82818172ringlet
roundlet9209222roundlet
ruble74521252ruble_
rubles83921702rubles
rule49938422ru_le_
ruled65822522ru_led
ruler54923342ru_ler
rules55234252ru_les
rundle73214232rundle_
rundles83214712rundles
rundlets9307362rundlets
rune45236292run_e_
runes55530222run_es
runkle103611542runkle_
runkled12399012runkled
runkles114111942runkles
runless72810422runless
runnel63510662runnel
runner63814462runner
runout6414872runout
runt46647982run__t
russet6319432russet
sublet82827242sublet
sunket103721362sunket
sunlit61516102sunlit
sunset63723632sunset
tonlet62924702tonlet
unled64021072_unled
unlit55025462_unlit
unmet74426392_unmet
unset54532432_unset
unwet84423172_unwet

Search took 7 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 Filter178691825510.436409841.7
2DLD Change Limit82551586.08013577.5
3Display Results58580.0301933.3
 (SQL Overall)178691586.54627297.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.