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

217 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
gumlines1123857(None) 
gumline102810111gumline_
guylines12236941guylines
cutlines102413272cutlines
fulmines1357782fulmines
gamines103618462gam_ines
guanines989772guanines
gullies84717312gulli_es
gumlike14317402gumlike_
gumminess1454972gumminess
gummites1346172gummites
guyline11258172guyline_
hemlines13310622hemlines
outlines82418092outlines
purlines103514052purlines
sublines10315782sublines
tumplines1346022tumplines
airlines8312793airlines
alines65735223__alines
alumines10411683alum_ines
amines84727983_am_ines
ammines11312673_ammines
anilines8415143anilines
beelines103312803beelines
berlines102315453berlines
bluelines1145833bluelines
bowlines133211623bowlines
bullies94121893bulli_es
bumblings16194753bumblings
bumkins15318013bumkin_s
bumpiness1535283bumpiness
buntlines11207153buntlines
burliness1137833burliness
bustlines11207353bustlines
bylines1239243_bylines
carlines103521653carlines
cholines132214493cholines
clines84926043__clines
combines142814623combines
complines15312833complines
cuisines1049373cuisines
culices113713123cu_lices
cullies94419963culli_es
cullises103111313cullises
cumins103314933cum_in_s
cummins1358963cummin_s
curliness1138553curliness
curlings114110383curlings
cutline92914543cutline_
cymlings1634213cymlings
cymlins1436693cymlin_s
declines113315803declines
domaines11611063domaines
domines102918973dom_ines
drumlins1144993drumlin_s
dualizes1838823dualizes
dummies123012133dummi_es
dumpiness1435653dumpiness
dumpings14295763dumpings
dumplings15213853dumplings
dunlins849553dunlin_s
ermines9416673erm_ines
eucaines1038513eucaines
famines123216263fam_ines
felines104718073_felines
figulines1345043figu_lines
fulmine1257963fulmine_
fulmined1454333fulmined
gallies84122713galli_es
gamine94620153gam_ine_
gaminess112911063gam_iness
gamings114610913gam_ings
gamins94420053gam_in_s
gantlines1039333gantlines
gasolines1047483gasolines
gemlike14206813gemlike_
gemminess1464643gemminess
gillies84120963gilli_es
gimmies123010113gimmi_es
girlies83013703girli_es
glides84518863g__lides
glimes94717523g__limes
glints75714213g__lints
glycines1445083glycines
goalies8316023goali_es
goblins1039243goblin_s
godliness1136593godliness
godlings11367493godlings
goslings10297553goslings
gradines103615253gradines
graplines1237353graplines
gremlins1136053gremlin_s
gruelings1163763gruelings
grumpiness1543273grumpiness
guanine8810543guanine_
guanins8810013guanin_s
guidelines1243363guidelines
guides84118283gu__ides
guiles73919283gu__iles
guiling93214213guilin_g
guiltiness1144193guiltiness
guinea737613gu__inea
guineas836753gu__ineas
guises74216313gu__ises
gulches13398113gu_lches
guldens9356573gu_ldens
gules64831043gu_l__es
gullied93812063gulli_ed
gulling94019563gullin_g
gumless10228273guml_ess
gummier12349473gummi_er
gummiest13269033gummi_est
gumming133810193gummin_g
gummite1236133gummite_
gummoses1344743gummoses
gumshoes1444123gumshoes
gumtrees1143883gumtrees
gunfires1235063gunfires
gunflints1342773gunflints
gunites8313123gu_nites
gunnies83413123gunni_es
gunnings10346733gunnings
guppies123310523guppi_es
gurries83515953gurri_es
gushiness13206853gushiness
gussies82813303gussi_es
gustiness10189893gustiness
gutlike12308653gutlike_
gutsiness10226963gutsiness
hemline12311073hemline_
hiplines13310593hiplines
homines123518643hom_ines
hotlines11811643hotlines
humpiness1635773humpiness
hurlies103315333hurli_es
hurlings12388213hurlings
hyalines14169333hyalines
imines84918353_im_ines
inclines10313143inclines
isolines8312303isolines
jawlines18126363jawlines
jumpiness2034293jumpiness
kaolines1239293kaolines
lines57054573___lines
lumpiness1336483lumpiness
lupines93912503lu_pines
malines93625603_malines
marlines103818713marlines
midlines112613333midlines
millines102718063millines
mines75651953__m_ines
muhlies1238933muhli_es
mullites10411643mullites
mummies103812843mummi_es
murines93718223mu_rines
muslins9312213muslin_s
mutines93117823mu_tines
myelines1337123myelines
nuclides1146553nuclides
opalines10311423opalines
outlies72421993outli_es
outline72321333outline_
outlined92512953outlined
outliner82412113outliner
outliners9228363outliners
outlives112511763outlives
pemolines1348623pemolines
potlines10714213potlines
pralines102217723pralines
prolines102619693prolines
pulings103511323pu_lings
pumices1338273pum_ices
purines94420763pu_rines
purline93516533purline_
purlings113910283purlings
purlins93415423purlin_s
quinines172410203quinines
ratlines83815293ratlines
reclines103718543reclines
redlines93916083redlines
relines75331323_relines
romaines10512523romaines
rulings83310383ru_lings
rumblings14184633rumblings
rummies113212793rummi_es
salines74029413_salines
setlines8312743setlines
simlins9311843simlin_s
skylines1535703skylines
splines94718893_splines
sublimes12310033sublimes
subline9316893subline_
sullies74122233sulli_es
supines94216383su_pines
surliness939943surliness
taglines92210833taglines
timelines1148443timelines
toplines102412563toplines
towlines112610343towlines
tramlines1139843tramlines
tumblings14184843tumblings
tummies113012033tummi_es
tumpline1237113tumpline_
turbines1039903turbines
uglies7412323_ugli_es
ugliness936863_ugliness
umbones1138013_umbones
umpires1137813_umpires
undines8716083_undines
unlined82515803_unlined
unlinks11307403_unlinks
unlives102010953_unlives
uplinks13345613_uplinks
urines64724123_u_rines
valines104520213_valines
yummies14359533yummi_es
yumminess1653643yumminess

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622176.32623105.0
3Display Results2172170.0962260.4
 (SQL Overall)1786912176.82826170.3
 
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.