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

165 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
gallants9331037(None) 
callants104112141callants
gallant83517111gallant_
gellants9308281gellants
alants67722022_a_lants
ballasts1037932ballasts
callans94518472callan_s
callant94121222callant_
galavants1343942galavants
galivants1344202galivants
gallanted1145892gallanted
gallantly1344252gallantly
gallantry1343352gallantry
gallate83417122galla_te
gallates92815522gallates
gallets83517402gall_ets
galliots9228682galliots
gallivants1442602gallivants
gallnuts943922gallnuts
gallons83015952gallon_s
galloots9268962galloots
garlands1038322garlands
gelants82611442g_elants
gellant83214052gellant_
lallands9338572lallands
lallans74113532lallan_s
valiants1137792valiants
ablauts936083_ablauts
alands75418373_a_lands
alans55636173_a_lan_s
alant55742293_a_lant_
alkanes113812933_alkanes
alkanets12366233_alkanets
allanite8411093_allanite
allanites949803_allanites
allantois985003_allantois
allays94313743_alla_ys
allots64019173_all_ots
aslant6317753_aslant_
atlantes838553_atlantes
badlands1236673badlands
ballades114211643ballades
ballads104212913balla_ds
ballast9313993ballast_
ballets93719513ball_ets
ballonets1146723ballonets
ballons93916963ballon_s
ballots94116033ball_ots
callan83619603callan__
callas84526753calla__s
callets93821703call_ets
callings113613833callings
coolants1039943coolants
eggplants1342753eggplants
eluants737583_eluants
explants1737023explants
fallals103310193falla_ls
fallouts1137883fallouts
gabbarts1344063gabbarts
galagos938143ga_lagos
galahs105512673ga_la_hs
galanga936013ga_langa
galangas1046173ga_langas
galas65731643ga_la__s
galavant1246353galavant_
galaxes1538873ga_laxes
galbanum1343683galbanum
galbanums1442443galbanums
galeas74618513galea__s
galeate83916783galea_te
galenas83310343ga_lenas
galiots82311323ga_liots
galipots1145213galipots
galivant1247083galivant_
gallamines1345493gallamines
gallanting1245353gallanting
gallantries1254123gallantries
galleass935053galleass
galleins9258693galleins
galleons9258443galleons
gallet73630853gall_et_
galleta8399643gall_eta
galletas9308133galletas
galleys11369713gall_eys
galliards1194543galliards
galliass935423galliass
gallicas1136933gallicas
gallies84122713gall_ies
galling93921963gallin_g
galliot82214133galliot_
gallipots1243773gallipots
galliums1145963galliums
gallivant1344493gallivant_
gallnut847253gall_nut
gallon73715813gallon__
galloons9289703galloons
galloot82814223galloot_
gallops103211653gall_ops
gallous82813953gall_ous
gallows113513513gall_ows
galls64729323gall___s
gallus74313203gall__us
galluses936963galluses
galoots82410793ga_loots
galvanic1444513galvanic
galvanise1344883galvanise
galvanism1544523galvanism
galyacs1335273galya_cs
galyaks1534623galya_ks
gamelans11115843gamelan_s
ganglands1244453ganglands
gardant9314463gardant_
garland948703garlan_d
garments1139963garments
gaults74112783gaul__ts
gelant72821673g_elant_
giants74713503g__iants
gillnets934733gillnets
glands85314403g__lands
glans65125833g__lan_s
gleans75014743g_lean_s
glints75714213g__lints
gloats74515423g_loa_ts
grants73722473g__rants
guardants1143793guardants
gullets84013713gull_ets
hallahs133912463halla_hs
haplonts1345773haplonts
hollands12247273hollands
implants1237883implants
kalians11310183kalian_s
lallan63414173lallan__
lalland83810183lallan_d
llanos6108333__llanos
mallards1138323mallards
mallets93318493mall_ets
mallings113413093mallings
pageants1136693pageants
pallets93919303pall_ets
parlante1039693parlante
plants84921803__plants
radiants9259443radiants
raglans82410133raglan_s
replants102811243replants
salients839563salients
sallets73719653sall_ets
saltant7316773saltant_
savants1038653sa_vants
sealants82610743sealants
slants64819083__slants
taggants1044933taggants
talents7312013ta_lents
tallages92312003tallages
tallits73215993tall_its
topgallants1451193topgallants
ungallant1053313ungallant_
vagrants1246143vagrants
valiant10314623valiant_
vallate103016563valla_te
variants1139203variants
wallahs13409473walla_hs
wallas95719393walla__s
wallets103914833wall_ets
warrants1168503warrants
waxplants21142803waxplants

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.420425454.8
2DLD Change Limit1461621656.45322650.2
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.93625762.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.