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

73 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
scribbler1516422(None) 
scrabbler15195201scrabbler
scribble14175431scribble_
scribbled16174031scribbled
scribblers16183101scribblers
scribbles15184951scribbles
cribber13367662_cribb_er
cribbled15305802_cribbled
dribbler13316312_dribbler
fribbler15265952_fribbler
scrabble14196992scrabble_
scrabbled16154972scrabbled
scrabblers16213812scrabblers
scrabbles15206282scrabbles
scrabblier1642772scrabblier
scrambler15165042scrambler
scribbly17143622scribbl_y
scriber113910962scri_b_er
scrubber1434112scrubb_er
scrubbier1543332scrubbier
ascribable1643483ascribable_
brabbler11397373_brabbler
cobbler133311823_c_obbler
crabber133810733_crabb_er
crabbier14326803_crabbier
cribbed14407663_cribb_ed
cribbers14306443_cribb_ers
crippler14826713_crippler
dibbler124510283__dibbler
dribble12368603_dribble_
dribbled14376593_dribbled
dribblers14274453_dribblers
dribbles13348393_dribbles
dribblet13347543_dribblet
fribble14287783_fribble_
fribbled16305743_fribbled
fribblers16314193_fribblers
fribbles15287713_fribbles
grabbler13377693_grabbler
gribble12297273_gribble_
gribbles13307363_gribbles
nibbler11379273__nibbler
quibbler2132843_quibbler
rabbler113514093__rabbler
ribber103515493__ribb_er
ribbier1137593__ribbier
scabbier1435133sc_abbier
scabble13168653sc_abble_
scabbled15156303sc_abbled
scabbles14167983sc_abbles
schiller13296473schi_ller
scrabbly17164623scrabbl_y
scramble14177253scramble_
scrambled16164813scrambled
scramblers16183543scramblers
scrambles15146383scrambles
scrawler1345883scr_awler
scribal1137963scribal__
scribbling1742553scribbling
scribe104613533scri_b_e_
scribed124510643scri_b_ed
scribers12307953scri_b_ers
scribes113713203scri_b_es
scrimper1455753scri_mper
scrimpier1554243scrimpier
scripter12137773scri_pter
scrivener1443113scrivener
scrubbed1533853scrubb_ed
scrubbers1543363scrubb_ers
shriller1136823shri_ller
shrubbier1642193shrubbier
sprinkler1543573sprinkler
squabbler2242733squabbler

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641736.40623203.4
3Display Results73730.0135615.4
 (SQL Overall)178691736.57527177.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.