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

64 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
shoveller1517454(None) 
shoveler14165581shove_ler
shovelled16174411shovelled
shovellers16173781shovellers
groveller1354232groveller
hovelled15146842_hovelled
sheller103515892sh__eller
shoveled15195352shove_led
shovelers15174942shove_lers
sniveller1253702sniveller
beveller13387693_beveller
chiseller1443973chiseller
driveller1353853driveller
groveler12305843grove_ler
grovelled1454183grovelled
grovellers1443323grovellers
heller93322513_h__eller
holler93520613_ho__ller
homelier1338983_homelier
hosteller1245863_hosteller
hotelier1137633_hotelier
hoveled14209293_hove_led
hoverer13319823_hove_rer
leveller11317603_leveller
lovelier1136433_lovelier
modeller1136613_modeller
novelle1058233_novelle_
propeller1346623propeller
raveller11339263_raveller
reveller112912193_reveller
seller63824603s___eller
shapelier1444463shapelier
shelled113815093sh__elled
shellers112812583sh__ellers
shellier1138393sh__ellier
shelter103214963sh__elter
shelver134211063sh__elver
shielder1235183sh_ielder
shiverer14186663shive_rer
shoaler102610083sho__aler
shoalier1137073sho_alier
shoulder1234753sho_ulder
shovel124611323shove_l__
shovelful1882163shovelful
shoveling1635553shoveling
shovelling1744063shovelling
shovels13378393shove_l_s
shover124515993shov___er
showerer1436163showe_rer
shriller1136823sh_riller
shrivelled1742373shrivelled
slovenlier1351643slovenlier
smeller94212793s__meller
sneller73512853s__neller
sniveler1155253snive_ler
snivelled1353993snivelled
snivellers1352873snivellers
speller95415153s__peller
svelter10359673s__velter
sweller103012473s__weller
swivelled1662963swivelled
traveller1266603traveller
troweller1244563troweller
yodeller1244853_yodeller

Search took 10 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.810220606.2
2DLD Change Limit148641648.15618224.7
3Display Results64640.0331939.4
 (SQL Overall)178691648.99919856.8
 
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.