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

151 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
genseng93398(None) 
gensengs1043091gensengs
ginseng933431ginseng
censing104215262censing
ginsengs1042652ginsengs
lensing84015102lensing
mensing103915102mensing
sensing84116952sensing
tensing84616652tensing
agenting1039383agenting
banteng1046363banteng
bending114420893bending
benzene1836343benzene
ceasing104118263ceasing
cense75121403cense__
censed94016323cense_d
censer84516583cense_r
censers94313903censers
censes83721803cense_s
cessing103814813cessing
consent93723113consent
denning93515173denning
dense65923503dense__
densely1146713densely
denser74115193dense_r
densest83112473densest
denting94422183denting
denying123711293denying
easing74926463_easing
ending83220253_ending
enserf9310763_enserf
ensign737523_ensign
ensuing8239543_ensuing
evensong1242653evensong
feasing113916653feasing
fencing132411133fencing
fending123717603fending
fessing113812863fessing
flensing1246973flensing
ganging103216193ganging
gassing94216333gassing
gearing92818843gearing
gecking154111363gecking
geeing84313773ge_eing
geese64316003geese__
gelding103911793gelding
gelling93219763gelling
gemming13289153gemming
gender83517933gende_r
gendering12249753gendering
genders93616783genders
gene56237223gen_e__
genera71211713gen_era
genes65133093gen_e_s
geneses82613523geneses
genesis82510823genesis
genet66038683gen_e_t
genets75716663gen_ets
geneva1085853gen_eva
genie66124923genie__
genies75324943genie_s
genre66016803genre__
genres75515623genre_s
gens55740073gens___
genteel836753genteel
gentes75324163gente_s
gentling1048453gentling
genuine838373genuine
genuses83510883genuse_s
gerent73223103ge_rent
germen9612313germen_
germens1078633germens
getting93316563getting
geyser1036513geyse_r
geysers1135703geysers
ginning93313983ginning
godsend1084043godsend
gonging103713033gonging
goosing93314083goosing
greasing102811393greasing
greisen856503greisen_
greisens954653greisens
guessing1036243guessing
guising93511413guising
gunmen9348723gunmen_
gunnen7338713gunnen_
gunning93413173gunning
gunsel7339853gunse_l
gunsels8338133gunsels
henting113719653henting
jessing153710623jessing
kenning124010543kenning
leasing83920163leasing
lending94118533lending
lenient7313843lenient
lense54523433lense__
lensed74015473lense_d
lenses64620893lense_s
lensmen937883lensmen_
lenten6312883lenten_
lessen64212433lessen_
lessens7409383lessens
linsang835863linsang
mending114018683mending
mense75025633mense__
mensed93916543mense_d
menses84222453mense_s
menshen1236813menshen_
messing103916393messing
peasen84815963peasen_
peising103416763peising
penang92511113pen_ang
pendent10314723pendent
pending114119773pending
penmen10311493penmen_
penning103616493penning
pensee8417313pense_e
pensees9311203pensees
pentene9313793pentene
rending93924263rending
renting84026853renting
resend75016773re_send
resent63833623re_sent
reusing82516783reusing
rinsing82516113rinsing
seising84018863seising
sending94221373sending
sense55526823sense__
sensed73918163sense_d
sensei64712593sense_i
senseis73310643senseis
senses63923943sense_s
teasing83918513teasing
tending94419163tending
tense55225843tense__
tensed74817833tense_d
tensely1037363tensely
tenser64919433tense_r
tenses64722553tense_s
tensest72713313tensest
tenting84621153tenting
unsent63820963_unsent
unsung736983_unsung
vending124015263vending
venene92912523ven_ene
venging123710943venging
venting114218093venting
versing112314193versing
wending123816843wending
yenning11369493yenning
yessing113210063yessing

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.403443402.0
2DLD Change Limit1340271516.16021757.6
3Display Results1511510.0463282.6
 (SQL Overall)1786911516.60927037.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.