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

69 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
grillage105561(None) 
grillade1085141grillade
grillages1174941grillages
arillate8412982arillate
grillades1194542grillades
grille74315742grill__e
millage103112742_millage
pillage103412592_pillage
spillage1146262spillage
tillage83111332_tillage
treillage1043672treillage
village113610822_village
arillode944963arillode
armillae1045563armilla_e
axillae14248233axilla_e
bricolage1453153bricolage
collage102813753_collage
cribbage1542973cribbage
diallage1045233diallage
driftage1342933driftage
drillable1245133drillable
gallate83417123g_allate
ghillie11326353ghill_ie
gillie74816943g_ill_ie
gorilla836973gorilla__
gorillas946373gorilla_s
graftage1343683graftage
graylag1283113graylag_
graylags1372983graylags
greylag1262553greylag_
greylags1392313greylags
grill64617893grill___
grilled94012833grill_ed
griller84513353grill_er
grillers93810803grillers
grillery12355503grillery
grilles83715023grill_es
grilling103811533grilling
grills74314803grill__s
grilse7399503gri_l_se
grimace1255083gri_mace
milage93414123_mi_lage
mileage10299313_mileage
millages113212893_millages
oeillade943953oeillade
permillage1552953permillage
pillaged12298083_pillaged
pillager11278543_pillager
pillages113012603_pillages
primage12169143pri_mage
pupillage1442753pupillage
rille55728733_rill__e
rivage1038843_ri_vage
silage72715303_si_lage
smallage1145183smallage
soilage8169353soi_lage
spillages1256073spillages
sullage859913_sullage
tallage82712073_tallage
thirlage1243813thirlage
tillages93011243_tillages
tollage82610163_tollage
treillages1143463treillages
triage72812893tri__age
triplane1039113triplane
ullage739043__ullage
villae95615383_villa_e
villager12267503_villager
villages123010593_villages

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit146162697.59619242.0
3Display Results69690.0302300.0
 (SQL Overall)178691697.78222962.1
 
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.