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

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

248 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
referred129783(None) 
deferred13106361deferred
preferred1555001preferred
refereed12149691refereed
referrer11136051referrer
deferrer12135592deferrer
deterred10137802deterred
inferred12248352inferred
preferrer1443892preferrer
recurred1137092recurred
refected142311662refected
refeed104717622refe__ed
refelled122810172refelled
refenced1438992refenced
referee101615752refe_ree
referees111310412referees
referral1144402referral
referrers12125372referrers
refired115116992ref_ired
reforged13268702reforged
reformed14249602reformed
refried113513872ref_ried
regeared1039432regeared
remerged12149172remerged
reperked15177792reperked
reserved121010582reserved
reverbed14269222reverbed
revered112819332reve_red
reversed122711612reversed
reverted122714712reverted
rezeroed1835992rezeroed
afeared1176833_afeared
averred11237593_averred
conferred1537753conferred
debarred12165633debarred
decerned1237263decerned
defeated132812163defeated
defected15289973defected
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferral1244353deferral
deferrers13115153deferrers
deforced15247373deforced
deformed15248263deformed
degermed1335453degermed
demerged13157603demerged
demurred1234933demurred
depermed1436453depermed
deserted101012203deserted
deserved13108133deserved
deterged11127923deterged
deterrer9137013deterrer
emerged11158213_emerged
emersed10138513_emersed
erred65915673___erred
everted112711853_everted
exerted152210053_exerted
feared106320433__feared
ferrel92810203__ferrel
ferret93021173__ferret
ferried113411523__ferried
fevered14339723feve_red
furred104514433__furred
inferrer11217443inferrer
interred92615263interred
jeered143912793je_e_red
leered73816223le_e_red
levered114212303leve_red
metered103514013mete_red
misreferred1752193misreferred
offered1436143offe_red
peered93819493pe_e_red
petered103314973pete_red
preaverred1642763preaverred
preferrers1542983preferrers
prefired144310753pref_ired
preformed17176203preformed
preserved15107563preserved
raftered1237663raftered
reared75930013r__eared
rearmed103912823re_armed
rebelled113110333rebelled
rebored105015883re_bored
rebred95816353r__ebred
rebreed104611073re_breed
reburied1137913reburied
recarried1244983recarried
receded112713043rece_ded
received1437983received
recessed1139713recessed
reconferred1783663reconferred
recorded122511063recorded
recorked15239853recorked
recurved1436493recurved
redeemed1235593redeemed
redefied1368223redefied
redenied10511283redenied
redried93714893re_dried
reearned948883reearned
reeded84022563re_e_ded
reefed103816583re_e_fed
reeked113717643re_e_ked
reeled74725533re_e_led
reemerged1354403reemerged
reested82916233re_ested
reeved104118713re_e_ved
refaced133713573ref_aced
refed93921923ref___ed
refeeds11368973refe__eds
refeel93913243refe__el
refence12312233refence_
refences13311843refences
refer84822143refe_r__
referenced1676863referenced
referenda1343073referenda
referent112813423referent
referrals1243493referrals
referring1338033referring
refers93921083refe_r_s
reffed134712513ref__fed
refigured1443933refigured
refiled114318653ref_iled
refilled12278673refilled
refilmed14235813refilmed
refined114720003ref_ined
refire95419473ref_ire_
refires104820313ref_ires
refitted12309413refitted
refixed183611153ref_ixed
reflated123514293reflated
reflected1547983reflected
reflexed1975253reflexed
reflowed15126903reflowed
refluxed1954353refluxed
refolded1337063refolded
reforge11259033reforge_
reforges12249333reforges
reformer13217953reformer
reframed1437853reframed
refreshed1685613refreshed
refries104419733ref_ries
refueled1286573refueled
refuelled1364513refuelled
refuged125410873ref_uged
refunded1336953refunded
refused115114443ref_used
refuted114313803ref_uted
regarded11279803regarded
regorged11227333regorged
reheard11309023rehear_d
rehearsed13305913rehearsed
reheated122415003reheated
reheeled1236773reheeled
rehemmed1634153rehemmed
rehired115013153re_hired
reinterred1145153reinterred
rejected182710113rejected
rekeyed1536163reke_yed
relearned1035633relearned
released9310243released
relented92614943relented
remarked15209243remarked
remarried1244933remarried
remedied1237953remedied
remelted11310153remelted
remended123010393remended
remerge10148923remerge_
remerges111110203remerges
rendered102512263rendered
reneged92010763rene_ged
renested92212953renested
renewed11309993rene_wed
reoffered1643313reoffered
repaired1148953repaired
reparked15208923reparked
repealed113211873repealed
repeated113117443repeated
repegged1334893repegged
repelled113111593repelled
repented112614983repented
reported11312703reported
repoured1139563repoured
required18156833required
rerented92516163rerented
rescored114513103rescored
resealed92713973resealed
reseated93220263reseated
resected112514743resected
resecured1245533resecured
reseed74823293rese__ed
reseeded1038093reseeded
reseized1839213reseized
resented92716963resented
reserve101011203reserve_
reserver11119633reserver
reserves111011983reserves
resewed113011823rese_wed
resorbed1138533resorbed
resorted9313493resorted
respired1148993respired
restored96417193restored
resurged1038623resurged
retarded102410753retarded
reteamed1138013reteamed
retested92212533retested
retired84620143re_tired
retorted9312333retorted
retried84419153re_tried
returned9459133returned
revealed123211213revealed
reveled113917753reve_led
revelled123712743revelled
revenged1337553revenged
revenued1237223revenued
revere94621253reve_re_
reverend12288853reverend
reverer103815833reve_rer
reverers113113153reverers
reveres103621343reve_res
reverie103615163reverie_
reveries112518513reveries
reverse103913743reverse_
reverser113010483reverser
reverses112513513reverses
reverter114812873reverter
revested122612243revested
revetted122210943revetted
rewarded13229523rewarded
rewarmed14257433rewarmed
reweaved1535953reweaved
rewedded1434513rewedded
rewelded1335893rewelded
rewetted12228353rewetted
rewired115413283re_wired
reworded13228103reworded
reworked16247773reworked
rezeroes1737143rezeroes
riverbed14245143riverbed
rogered939553roge_red
secerned1136103secerned
severed113513863seve_red
sewered112911243sewe_red
telfered1234883telfe_red
unfeared121511013unfeared
veered103612743ve_e_red
veneered1235983veneered
wafered14288433wafe_red

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.410435831.7
2DLD Change Limit1461622487.01320841.6
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.51623774.7
 
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.