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

212 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
fescue113749(None) 
fescues1236781fescues
rescue8313001rescue
fence105319912fenc_e
fesse86116332fes_se
miscue10412222miscue
rescued10410042rescued
rescuer939032rescuer
rescues9312752rescues
ascus75013583_ascus
bascule1136573bascule
basque17259083basque
bescour1145203bescour
beside95114613beside
besmut10310653besmut
bestud9439303bestud
bisque17257843bisque
bosque17257733bosque
casque17299273casque
cecum11611843ce_cum
cercus105013153cercus
cesium1039583cesium
cestus84412913cestus
cue57544183___cue
cuscus1038113cuscus
deduce1079253deduce
deice84320033deic_e
dengue838253dengue
descry1256183descry
desire7415303desire
deuce84517493deuc_e
discus94512113discus
eche97520283_e_che
ecu56828233_e_cu_
ecus65421463_e_cus
educe84313453_educe
emcee9315943_emcee
endue64215353_endue
ensue54013833_ensue
escape103811663_escape
escar74011993_escar
eschew1436333_eschew
escot75320083_escot
escuage1035113_escuage
escudo943373_escudo
esne47018793_es_ne
excuse1537423_excuse
face96140123f_ac_e
farce104925323farc_e
farcie114816473farcie
fasces114914543fasces
fascia1148703fascia
fasciae1247523fasciae
fascine12510583fascine
fease84824873fe_ase
feature1039853feature
feaze175216313fe_aze
fecal105119213fe_cal
feces105625363fe_ces
feck134923433fe_c_k
fecks145417853fe_cks
fecula113310053fe_cula
feculae12339203fe_culae
fecund1235433fe_cund
fee66862013fe___e
feeble1138253feeble
feeze174913823fe_eze
feirie939553feirie
feline94820143feline
felloe93513923felloe
felsite1039083felsite
female11310553female
feme96130543fe__me
femme125011433fe_mme
femur1038683fe_mur
fenced124412713fenced
fencer114613533fencer
fences114617113fences
fere76342233fe__re
feriae95618603feriae
ferine96422583ferine
ferlie92814053ferlie
ferrule1035863ferrule
ferrum1147453ferrum
ferule93413203ferule
fes66551673fes___
fess76529163fes__s
fessed104515063fessed
fesses94820253fesses
fest74949443fes__t
festal94213563festal
fester94723513fester
festive1339773festive
fests85828043fes_ts
fetch134913473fetc_h
fetched163710473fetched
fetcher153510393fetcher
fetches153413893fetches
fete75734923fe__te
fettle93713123fettle
fetus85816543fe_tus
feu67843663fe__u_
feud86523023fe__ud
feued94715663fe__ued
feus75830753fe__us
fiacre1137623fiacre
fice95737113f_ic_e
fiche134616743f_iche
ficus105015493f_icus
fierce11348913fierc_e
fique1739143f_ique
fisc96819753fisc__
fiscal1139333fiscal
fiscs105311883fisc_s
fissure1036783fissure
fleche14299303fleche
fleece11369903fleec_e
flue75329853f__lue
focus105815883f_ocus
fondue104510493fondue
force105324273forc_e
fossae95510373fossae
fosse86119463fos_se
fresco1136473fresc_o
frescoed1436053frescoed
frescoer1345983frescoer
frescoes1357833frescoes
frescos1236813frescos
fucus105515893f_ucus
fugue94313373f_ugue
fuscous1256673fuscous
fuse76429993fus__e
fusee86224583fus_ee
fusile94313493fusile
fyce126316833f_yc_e
geste65920693ges_te
gesture839243gesture
hence104920043henc_e
issue559213_issue
jesse126012833jes_se
league758743league
lessee64116363lessee
masque17249383masque
mescal104113483mescal
mesclun1144013mesclun
mesne75116293mes_ne
mestee84523883mestee
miscued1239293miscued
miscues11312393miscues
miscut10614813miscut
mosque17287163mosque
muscae10410673muscae
muscle10310973muscle
nestle63013953nestle
obscure1145333obscure
oscule838193_oscule
peace95026083peac_e
pence94924453penc_e
perdue93912633perdue
pesade9311103pesade
pestle83215843pestle
recce9514563re_cce
recur74116843re_cur
recuse85519163re_cuse
recut74729243re_cut
reduce9713253reduce
reglue739703reglue
reissue745873reissue
resale64025543resale
rescale93215473rescale
rescore95616193rescore
rescuers1037363rescuers
resecure1047183resecure
resee54336333res_ee
reshoe92816483reshoe
reside74224933reside
residue8689863residue
resile64627673resile
resite64128453resite
resize154117723resize
resole64624183resole
resume8313783resume
revue81114453re_vue
risque15227453risque
roscoe839763roscoe
scud76221283__scud
scum85924523__scum
scup84822383__scup
scut65835543__scut
scute75520943__scute
secure8513533se_cure
seduce9610023seduce
segue6314413se_gue
seiche11811833seiche
sesame8311013sesame
slue45332193__slue
spue66025523__spue
sue35651463__s_ue
teacup1036253teacup
terce75721843terc_e
testae64216253testae
testee64323303testee
tissue637333tissue
tusche1136783tusche
usque14137733_usque
vendue10419013vendue
venue84918213ve_nue
vesicae12177703vesicae
vesicle12217923vesicle
vestee94319153vestee
vesture10310373vesture
viscus11428503viscus

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162125.40620850.2
3Display Results2122120.0633365.1
 (SQL Overall)1786912125.60931857.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.