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

176 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
galleons925844(None) 
galleins9258691galleins
galleon8278711galleon_
gallons83015951gall_ons
galloons9289701galloons
ballons93916962ball_ons
balloons103110522balloons
galleass935052galleass
gallein8299042gallein_
galletas9308132galletas
gallets83517402galle_ts
galleys11369712galle_ys
galliots9228682galliots
gallon73715812gall_on_
galloon82910642galloon_
galloots9268962galloots
gallops103211652gall_ops
gallous82813952gall_ous
gallows113513512gall_ows
aeons57624653_a__eons
aglycons1442973aglycons
ailerons849853_ailerons
aliens65619213_alie_ns
allees64521483_alle_es
alleges84212573_alleges
alleles73812033_alleles
alleys95113303_alle_ys
allods73615083_all_ods
allots64019173_all_ots
allows94517683_all_ows
alloys94014563_all_oys
azlons154110423_azl_ons
baleens938473ba_leens
ballers94421013balle_rs
ballets93719513balle_ts
ballon84117493ball_on_
balloon93711433balloon_
ballots94116033ball_ots
billions102211793billions
billons93013363bill_ons
bullions101710043bullions
caldrons1138063caldrons
callans94518473call_ans
callboys1585183callboys
callees94117783calle_es
callers94221963calle_rs
callets93821703calle_ts
callous93516603call_ous
colleens1036843colleens
cullions10219223cullions
dalapons1145443dalapons
dalles74222063dalle__s
daltons8310403da_ltons
falcons1239123fa_lcons
fallen93813373falle_n_
fallers103917993falle_rs
fallows133713973fall_ows
gabions102410053ga_bions
gables94222333gable__s
gaboons10289903ga_boons
gadroons1037013gadroons
galagos938143galago_s
galeas74618513ga_le_as
galena74911093ga_le_na
galenas83310343ga_lenas
galeres83514333ga_leres
gales65442483ga_le__s
galilees936333galile_es
galiots82311323ga_liots
galipots1145213galipots
gallant83517113gall_ant
gallants93310373gallants
gallates92815523gallates
galled84622863galle__d
galleria946473galleria
gallerias1047133gallerias
galleries10311703galleries
gallery11468743galle_ry
gallet73630853galle__t
galleta8399643galle_ta
galleted1038213galleted
galleting1137633galleting
galley104215453galle__y
galliass935423galliass
gallicas1136933gallicas
gallies84122713gall_ies
galling93921963gall_ing
galliot82214133gallio_t
gallipots1243773gallipots
galliums1145963galliums
gallnuts943923gallnuts
gallooned1144463gallooned
galloot82814223gall_oot
gallop93311383gall_o_p
galls64729323gall___s
gallstone1044833gallstone
gallstones1144833gallstones
gallus74313203gall__us
galluses936963galluses
gallying13328933gallying
galoots82410793ga_loots
galops94712623ga_l_ops
gambesons1442343gambesons
gamelans11115843gamelans
gammons1237973ga_mmons
ganglions1144063ganglions
gaolers83511563gaole_rs
gapless10349993gaple_ss
garcons102411643ga_rcons
gardens93312093garde_ns
garrons82713463ga_rrons
gascons10289103ga_scons
gaseous839503ga_seous
gasless8319013gasle_ss
gazillions2042703gazillions
gillers84216903gille_rs
gleans75014743g__leans
glens66519853g__le_ns
gluons738503g__luons
goalless935723goalle_ss
gudgeons11113943gudgeons
guldens9356573gulde_ns
gullets84013713gulle_ts
gulleys11438523gulle_ys
halcyons1644023halcyons
hallels103310133halle_ls
halloas104318463hall_oas
halloes104021523hall_oes
halloos103716743hall_oos
hallos95425103hall_o_s
hallows134417393hall_ows
halons95720713ha_l_ons
hellions11310023hellions
jillions15178283jillions
lallans74113533lall_ans
malisons1048783malisons
mallees93315973malle_es
malleoli1054053malleoli
malleolus1143513malleolus
mallets93318493malle_ts
malleus92911313malle_us
mallows123714323mall_ows
millions101712433millions
mulleins10277053mulleins
mullens93611313mulle_ns
mullions101910353mullions
napoleons1142833napoleons
nucleons1065483nucleons
paeons83915523pa__eons
pallets93919303palle_ts
pallors9314363pall_ors
pillions101610923pillions
pleons84213343__pleons
pollens93713303polle_ns
rellenos8125493rellenos
sallets73719653salle_ts
sallows103915553sall_ows
salmons93713263sa_lmons
salons63823693sa_l_ons
saloons74415323sa_loons
salterns8388903salterns
scallions1145783scallions
shalloons1245223shalloons
stallions946073stallions
talions7314113ta_lions
tallboys1374623tallboys
tallols73311363tall_ols
tallows103313743tall_ows
talons64019443ta_l_ons
valleys13407483valle_ys
villeins1136043villeins
wallets103914833walle_ts
walleyes1435603walleyes
wallops123410413wall_ops
wallows133613533wall_ows
zillions17168073zillions

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.423422437.4
2DLD Change Limit1461621766.32623105.0
3Display Results1761760.0632793.7
 (SQL Overall)1786911766.81226231.8
 
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.