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

50 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
boorishly174363(None) 
bookishly2143341bookishly
bearishly1774292bearishly
boorish123712592boorish__
boyishly1943662b_oyishly
foolishly1843762foolishly
moonishly1743732moonishly
ogrishly1544032_ogrishly
whorishly2143042whorishly
babyishly2242513babyishly
beamishly1973343beamishly
boarish123911913boarish__
boobish14338943boobish__
bookish163610023bookish__
boomingly1744793boomingly
boozily2135623boozi__ly
boringly1438403b_oringly
brashly15427613b__rashly
briskly16165403b__riskly
bristly12178063b__ristly
brutishly1743063brutishly
bullishly1744083bullishly
coltishly1744213coltishly
currishly1763943currishly
doggishly1842893doggishly
dollishly1643683dollishly
doltishly1643383doltishly
donnishly1643333donnishly
fairishly1843573fairishly
foppishly2242673foppishly
garishly1545693_garishly
goatishly1643383goatishly
hoggishly2042953hoggishly
loutishly1543743loutishly
mobbishly2142693mobbishly
modishly1744583_modishly
monkishly2143353monkishly
moorish123311783moorish__
mopishly1864053_mopishly
oafishly1754093_oafishly
offishly2063613_offishly
ogreishly1642523_ogreishly
owlishly1743593_owlishly
poorish123712303poorish__
popishly1844193_popishly
roguishly1642973roguishly
sottishly1543763sottishly
tonishly1445523_tonishly
voguishly1942683voguishly
wolfishly2143023wolfishly

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 Filter1786911486410.420425454.8
2DLD Change Limit148641507.78319098.2
3Display Results50500.0163125.0
 (SQL Overall)178691508.21921741.2
 
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.