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 “gilders” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
gilders9421246(None) 
gelders93812571gelders
gilder84415531gilder_
gillers84216901gillers
girders9379941girders
gliders94811841gliders
guilders1035511guilders
wilders113513501wilders
aiders74524632ai_ders
alders74218422_alders
bidders114012312bidders
biders94822802bi_ders
bilkers134711862bilkers
billers94720832billers
binders103920742binders
birders103913262birders
builders1146742builders
ciders94620092ci_ders
cinders104617762cinders
eiders74321362ei_ders
elders74817302_elders
fielders12156772fielders
filers94623722fil_ers
fillers104320212fillers
filmers124211292filmers
filters103816552filters
finders113717872finders
folders113514392folders
gadders103611502gadders
ganders93521702ganders
gelder84613712gelder_
genders93616782genders
gibbers124710982gibbers
gibers95114662gi_bers
gilbert10310762gilbert
gilberts1134182gilberts
gilded94413222gilde_d
gilds75417522gild__s
giller74519732giller_
gingers94118642gingers
ginners84314222ginners
gippers123212082gippers
girder84312062girder_
girdlers10195402girdlers
givers104817712gi_vers
glider84614262glider_
glides84518862glide_s
gluers75011152g_luers
golder84417602golder_
golfers114410082golfers
graders94716012graders
gridders11286292gridders
grillers93810812grillers
grinders103410422grinders
guiders94111112guiders
guilder945912guilder_
guldens9356572guldens
gulpers10299012gulpers
hiders104919652hi_ders
hillers103718732hillers
hinders113718502hinders
holders113715902holders
idlers74012812_idlers
jilters144211962jilters
kidders13399172kidders
killers114215582killers
kilters113813602kilters
melders103213912melders
mildens10339932mildens
milder93818452milder_
mildews13365882mildews
milers84625162mil_ers
milkers134411612milkers
millers93621342millers
milters93619092milters
minders103720122minders
molders103315552molders
oilers64721192oil_ers
pilfers1238962pilfers
pinders103720472pinders
polders103617372polders
ridders93612492ridders
riders74123902ri_ders
sidlers83414232sidlers
sillers73822102sillers
silvers104714042silvers
sliders83515222sliders
solders83517772solders
tildes74513962tilde_s
tilers63523502til_ers
tillers73418742tillers
tilters73315952tilters
tinders84219172tinders
welders113313412welders
widders123512272widders
wielders12196612wielders
wilder103616472wilder_
willers103517912willers
winders113721262winders
yielders12164742yielders

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711003.17033965.6
3Display Results1001000.0303333.3
 (SQL Overall)1786911003.57649969.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.