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

205 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
forfend143541(None) 
forefend1545601forefend
forfends1544831forfends
forced126316522force_d
forded115020392forde_d
forefends1644492forefends
forfeit1339202forfeit
forfended1743742forfended
forged115519322forge_d
forked145217142forke_d
formed125021172forme_d
fornent10312932fornent
forwent13310532forwent
friend10388932f_riend
offend13365662_offend
portend103411192portend
barfed125416383barfe_d
bartend1038753bartend
boffed15369483boffe_d
bookend14396643bookend
bored85034303bor_e_d
boreen8314313boreen_
boreens9310403boreens
borked135117293borke_d
coifed124113063coife_d
commend144010183commend
compend144010303compend
contend103511893contend
corded105923353corde_d
cored85044223cor_e_d
corked135020783corke_d
corned95224523corne_d
cornfed1337383cornfe_d
defend113910493_defend
doffed14428503doffe_d
faciend1334803faciend
farced125216533farce_d
farded114518953farde_d
fared95842343far_e_d
farfel124310433farfe_l
farfels13348213farfels
farmed125117663farme_d
farted105121783farte_d
fend84832973___fend
feoffed1332813feoffe_d
ferment12315573ferment
fervent13310063fervent
fiend95312983f__iend
fifed125115973f_ife_d
fired94829743fir_e_d
firmed125411883firme_d
foaled104515963foale_d
foamed126014403foame_d
fobbed144112613fobbe_d
foemen11310523foemen_
fogged125518373fogge_d
foiled104618403foile_d
foined105915013foine_d
folded114212793folde_d
foment113718303fo_ment
fond86330953fo___nd
fonded115717043fonde_d
fooled104317823foole_d
footed104418623foote_d
fopped144012673foppe_d
foraged124812283foraged
foramen12310533foramen_
foramens1337823foramens
forayed14368593forayed
forbad122710503for_bad
forbear1237523forbear
forbid123312433for_bid
force105324273force__
forceps14466983forceps
forcer114917343force_r
forcers124215713forcers
forces114422133force_s
forcing134013753forcing
ford86835493for___d
fordid113512053for_did
fording123717043fording
fordone1149383fordone
fore78351473for_e__
foreby1438633for_eby
foredid1238503foredid
foredo10510823for_edo
forefeel14105513forefeel
forefeet14129393forefeet
forefelt14117363forefelt
forefended1843243forefended
forego1038903for_ego
forehand1537693forehand
forehead1537893forehead
foreland1239013foreland
foremen12412923foremen_
fores85847103for_e_s
forest94926743for_est
forewent1439423forewent
forfeited1643793forfeited
forfeits1445803forfeits
forfending1844183forfending
forge95126943forge__
forger104820773forge_r
forgers115218183forgers
forgery14419303forgery
forges105024263forge_s
forget106326393forge_t
forgets113813793forgets
forging124114723forging
forgone1139343forgone
forint9325023for_int
forker134717903forke_r
forkers144615783forkers
forking154014843forking
formant123416003formant
forme105225993forme__
formee113919943forme_e
former114221403forme_r
formers128217953formers
formes114623713forme_s
forming133615733forming
forspent1348163forspent
forte86131463forte__
fortes95327183forte_s
fortune1068303fortune
fortuned1285323fortuned
forward1438293forward
forzandi2143043forzandi
forzando2142763forzando
fouled104315973foule_d
found94917843fo__und
fourfold1542213fourfold
fowled133914103fowle_d
foxed165115213fo_xe_d
fraena938063f_raena
freed95223543f_r_eed
fremd115010323f_r_emd
frena85915273f_r_ena
fried95322913f_rie_d
friends11396743f_riends
frond95316343f_r_ond
frowned14348833frowned
frozen18408443frozen_
furled104717053furle_d
furred104514433furre_d
godsend1084043godsend
golfed11569763golfe_d
goofed114911383goofe_d
gored75227083gor_e_d
gorged95016983gorge_d
gorhen1038903gorhen_
gorhens1137183gorhens
gormand1157453gormand
gormed105013833gorme_d
hoofed134614893hoofe_d
horded115420483horde_d
horned105718703horne_d
horrent10313553horrent
horsed105321083horse_d
kerfed14358233kerfe_d
loafed104011153loafe_d
lorded84916733lorde_d
mordent10313993mordent
moreen8313343moreen_
moreens939963moreens
morgen9312203morgen_
morgens10310463morgens
norland837163norland
normed95014543norme_d
offed12359163_offe_d
offends14234293_offends
orbed85516193_orbe_d
oread64619603_or_ead
orient6322533_orient
perpend12259353perpend
pored85234513por_e_d
porked134717623porke_d
ported94223243porte_d
portends11358963portends
portent93619643portent
poufed12449713poufe_d
propend123311273propend
protend104012793protend
rend56136573__r_end
rolfed104510523rolfe_d
roofed105214743roofe_d
sorbed94916523sorbe_d
sorbent92915243sorbent
sored66141783sor_e_d
sorned74820043sorne_d
sorted74523713sorte_d
surfed103814463surfe_d
torment9316173torment
torrent7313413torrent
torten65314353torten_
trend64817453_tr_end
turfed103110963turfe_d
wolfed13428013wolfe_d
woofed134511203woofe_d
worded114316623worde_d
worked145314703worke_d
wormed124314303worme_d
worsen95513873worsen_
worsened1236053worsened
worsens104610263worsens

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272055.90622693.4
3Display Results2052050.0603416.7
 (SQL Overall)1786912056.37228043.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.