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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

119 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
herder10451646(None) 
harder105022401harder
header104422541header
heder95623641he_der
heeder104216041heeder
herded114215641herded
herders113914121herders
aerier64823152aerier
beader94623792beader
bedder104215792bedder
bender95223302bender
birder94915492birder
border94419972border
carder94524182carder
ceder85322242ce_der
cheder125113492che_der
corder94322882corder
deader84220472deader
derider93214972derider
eerier64320022eerier
eider64624742_eider
elder64020022_elder
ender64325862_ender
feeder103513842feeder
fender103718722fender
gelder84613712gelder
gender83517932gender
girder84312062girder
hander104526432hander
harden105718532harden
hardier114721542hardier
harmer114719552harmer
harper115018402harper
headed114020472headed
headers113819392headers
headier113212952headier
healer94221802healer
heaper114119522heaper
hearer94323642hearer
heater94828302heater
heaver124819672heaver
heders104119762he_ders
hedger114912652hedger
heeded114215762heeded
heeders114213742heeders
heeler93917312heeler
hefter124313922hefter
heifer1238202heifer
heller93322512heller
helper114313092helper
hemmer134112642hemmer
hepper133412662hepper
herbed123513452herbed
herbier1239592herbier
herd84933062herd__
herdic123112302herdic
herdmen13238452herdmen
herds96424682herd_s
here76447102her_e_
heredes11313132heredes
heres86245902her_es
heroes94923822heroes
herpes115517322herpes
hewer115719932he_wer
hexer155116682he_xer
heydey1634632heydey
hider95024082h_ider
hinder104120062hinder
hirer85423122hir_er
hoarder11329232hoarder
holder104619652holder
horde94623052horde_
horded115420482horded
hordes104921632hordes
hurdler113610002hurdler
hurler94717222hurler
hurter93915852hurter
jerker17369042jerker
larder73720972larder
leader74824652leader
lender73921272lender
lewder10479612lewder
melder93915812melder
mender93520792mender
mercer105214202mercer
merde84320122merde_
merdes94518602merdes
merer75126232mer_er
merger95016482merger
murder93613782murder
needer73614952needer
nerdier83110352nerdier
order65019362_order
perter84422282perter
reader73628292reader
redder83918142redder
render74024142render
reorder8239482reorder
seder64826762se_der
seeder74320772seeder
sender73824412sender
serer55935512ser_er
serger73819742serger
server94917712server
shedder12339322shedder
tedder83312162tedder
tender74121842tender
termer85717252termer
terser67317822terser
vender103418422vender
verger104315702verger
verier94620962verier
verser94516962verser
warder104020272warder
wedder113612302wedder
weeder103315512weeder
weirder1144922weirder
welder102914412welder
yarder103813972yarder

Search took 3 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 Filter178691825510.346516448.0
2DLD Change Limit825511192.50033020.4
3Display Results1191190.0462587.0
 (SQL Overall)1786911192.89261788.0
 
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.