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

196 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
galliot8221413(None) 
galiot72322591ga_liot
galliots9228681galliots
gallipot1145941gallipot
galloot82814221galloot
allot54933872_all_ot
ballot84624092ball_ot
galiots82311322ga_liots
galipot1049542galipot
gallant83517112gallant
galleon8278712galleon
gallet73630852gall_et
gallic9411642galli_c
gallica1047462gallica
gallied94115002gallied
gallies84122712gallies
galling93921962galling
gallipots1243772gallipots
gallium1037942gallium
gallnut847252gallnut
gallon73715812gall_on
galloon82910642galloon
galloots9268962galloots
gallop93311382gall_op
galoot72719162ga_loot
gaslit7513502gasli_t
hallot95426782hall_ot
tallit63422732talli_t
alist56136783_a_list
alit46155693_a_li_t
aliyot93611713_aliyot
allied74217153_allied
allies63827673_allies
allium8311243_allium
allod64418383_all_od
allots64019173_all_ots
allow85420663_all_ow
alloy85519973_all_oy
ballast9313993ballast
ballet84733973ball_et
ballies93725743ballies
balling104424763balling
ballista1045803ballista
ballon84117493ball_on
balloon93711433balloon
ballots94116033ball_ots
billion92212173billion
bullion91911033bullion
callant94121223callant
callboy1465833callboy
callet84536763call_et
calling103826773calling
calliope1256223calliope
callow114714663call_ow
cellist9314423cellist
challot123613263chall_ot
cullion91910233cullion
dallied93713613dallied
dallier84215373dallier
dallies84023193dallies
daylit10512493dayli_t
diallist949553diallist
falling113621583falling
fallout10313503fallout
fallow124713853fall_ow
gabion93211033ga_bion
gabling113514543gabling
gait56150193ga__i_t
galago838903galago_
galagos938143galagos
galilee8312213galilee
galipots1145213galipots
gall56335993gall___
gallants93310373gallants
gallate83417123gallate
galled84622863gall_ed
gallein8299043gallein
galleins9258693galleins
galleons9258443galleons
gallery11468743gallery
galleta8399643galleta
gallets83517403gallets
galley104215453gall_ey
galleys11369713galleys
gallfly1433523gallfly
galliard10125753galliard
galliass935423galliass
gallican1155333gallican
gallicas1136933gallicas
galliums1145963galliums
gallivant1344493gallivant
gallnuts943923gallnuts
gallons83015953gallons
galloons9289703galloons
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galls64729323gall__s
gallus74313203gall_us
gally95026173gall__y
gallying13328933gallying
galoots82410793ga_loots
galop84716223ga_l_op
gambit114714213gambi_t
ganglion1044393ganglion
gaoling93314653gaoling
garlic9310043garli_c
garlics1038013garlics
gaslight1395343gaslight
gault65128483gaul__t
gavot9321123ga__vot
gazillion1942803gazillion
gellant83214053gellant
gelling93219763gelling
giglot84013133gigl_ot
gillie74816943gilli_e
gillied95512313gillied
gillies84120963gillies
gilling93520383gilling
gillnet839733gillnet
glint66830183g__lint
golliwog1341823golliwog
griot65328413g__riot
gullet74924833gull_et
gullied93812063gullied
gullies84717313gullies
gulling94019563gulling
hallo85127553hall_o_
halloa94918123hall_oa
halloo95118973hall_oo
halloos103716743halloos
hallos95425103hall_os
halloth134111253hall_oth
hallow124818323hall_ow
harlot94422803harl_ot
hellion10311133hellion
jillion14188933jillion
lalling83519623lalling
maillot9312173maillot
mallet84433053mall_et
malling103623663malling
mallow114014743mall_ow
melilot9311083melilot
million91813143million
mullion91911173mullion
paletot9413713paletot
pallet84232653pall_et
pallia83015593palli_a
pallial92911253pallial
palliate10311893palliate
pallid93915283palli_d
pallier94417163pallier
palliest102814633palliest
palling104024483palling
pallium1149013pallium
pallor8313673pall_or
palmist112814343palmist
patriot9314533patriot
phallist1338983phallist
pillion92011703pillion
pollist9816603pollist
rallied83514083rallied
rallier73816273rallier
rallies73823343rallies
ralline73518413ralline
rallyist1145363rallyist
reallot7312133reall_ot
sallet63734543sall_et
sallied83316953sallied
sallier73320423sallier
sallies73227813sallies
sallow94315753sall_ow
scallion1046793scallion
shallot103614133shall_ot
stallion837513stallion
talion6317713ta_lion
talipot949723talipot
tallboy1265143tallboy
tallest7317093tallest
tallied83314753tallied
tallier72817213tallier
tallies73624603tallies
tallis63319963talli_s
tallish103313583tallish
tallith102913063tallith
tallitoth1252563tallitoth
tallits73215993tallits
tallol63612223tall_ol
tallow93714203tall_ow
wallet93327093wall_et
wallie93216803walli_e
wallies103320743wallies
walling113520973walling
wallop113310293wall_op
wallow123913513wall_ow
zillion16188773zillion

Search took 9 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.423422437.4
2DLD Change Limit1340271968.01316726.2
3Display Results1961960.0802450.0
 (SQL Overall)1786911968.51620983.0
 
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.