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

75 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
scrawnier144364(None) 
scrawlier1443901scrawlier
brawnier13216722_brawnier
crawlier13216872_crawlier
scraggier1344132scraggier
scrappier1544422scrappier
scrawler1345892scraw_ler
scrawniest1543482scrawniest
screwier1346432screw_ier
sprawlier1443292sprawlier
strawier1137492straw_ier
brainier102510233_brainier
brannier10218933_brannier
brawlier13267043_brawlier
brownier13226913_brownier
cannier94014163_c_annier
crabbier14326803_crabbier
craftier1376193_craftier
craggier12116063_craggier
crampier14288903_crampier
cranker133612783_cra_nker
crankier14339163_crankier
crannied1137893_crannied
crannies10313013_crannies
crappier14288133_crappier
crawler123510463_craw_ler
crazier183610743_cra_zier
crowner124012603_crown_er
drawlier12225253_drawlier
fawnier13296363__fawnier
grainier9218903_grainier
prawner1246803_prawn_er
rainier71614263__rainier
scabbier1435133sc_abbier
scalier94316913sc_a_lier
scanner94411813sc_a_nner
scanter94215183sc_a_nter
scantier10309983sc_antier
scarier94017873sc_a_rier
scarifier1446653scarifier
scarrier10298453sc_arrier
scattier10267583sc_attier
scrabbler15195203scrabbler
scrabblier1642773scrabblier
scragglier1442283scragglier
scrambler15165043scrambler
scrannel1044033scra_nnel
scraper114513423scra__per
scrapie115010943scra_pie_
scrapies124612473scra_pies
scrapper1466973scra_pper
scratcher1635443scratcher
scratchier1744343scratchier
scrawled1445923scraw_led
scrawlers1434753scraw_lers
scrawliest1553813scrawliest
scrawling15195583scrawling
scrawniness1652153scrawniness
scrawny15213943scrawn__y
screener1037573screen_er
screwer124410073screw__er
scrimpier1554243scrimpier
scroggier1343133scroggier
scrounger1243443scrounger
scroungier1341963scroungier
scrubbier1543333scrubbier
scruffier1743303scruffier
semainier1144753semainier
spawner12347363s_pawn_er
sprawler1334653spraw_ler
strainer8512223strain_er
strander97112063stra_nder
stranger94715103stra_nger
strappier1345133strappier
tawnier10318463__tawnier

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.423422437.4
2DLD Change Limit148641756.37623312.6
3Display Results75750.0302500.0
 (SQL Overall)178691756.82926166.5
 
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.