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

177 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
gellant8321405(None) 
gallant83517111gallant
gelant72821671ge_lant
gellants9308281gellants
callant94121222callant
eluant6315092_eluant
gallants93310372gallants
gelants82611442ge_lants
gelling93219762gelling
reliant7319242reliant
replant93318532replant
sealant73118302sealant
alant55742293__alant
appellant1346353appellant
aslant6317753_aslant
avellan1037293avellan_
avellane1146263avellane
ballast9313993ballast
beleapt11310253beleapt
belling103825073belling
bellman1137183bellman_
bezant17814543be_zant
bezzant1746893bezzant
callan83619603callan_
callans94518473callans
callants104112143callants
cella75420313cella__
cellae84915933cella_e
cellar84514983cella_r
cellaret103713573cellaret
cellars93713693cellars
celling103921263celling
cellist9314423cellist
coolant9316463coolant
decant93524223de_cant
defiant11311923defiant
deplane10311413deplane
descant104315583descant
deviant11311313deviant
eclat7523603_ecla_t
eggplant1243973eggplant
elan46734243_e_lan_
eland65820393_e_land
elans55527753_e_lans
elegant8311503_elegant
elint55436473_e_lint
eluants737583_eluants
eluent6315483_eluent
errant6618733_errant
expellant1844963expellant
explant16310133explant
extant132714753_extant
fella84918653fella__
fellah124910773fella_h
fellahs13428393fellahs
fellas95116963fella_s
fellate10313433fellate
fellest10313753fellest
felling113321133felling
fenland1135693fenland
flagellant1454343flagellant
galavant1246353galavant
galivant1247083galivant
gallanted1145893gallanted
gallantly1344243gallantly
gallantry1343353gallantry
gallate83417123gallate
gallet73630853gall_et
galling93921963galling
galliot82214133galliot
gallivant1344493gallivant
gallnut847253gallnut
gallon73715813gallon_
gallons83015953gallons
galloot82814223galloot
gardant9314463gardant
garland948703garland
gelada837623ge_lada
gelate73421253ge_late
gelati73814533ge_lati
gelato73812953ge_lato
gelcap1136213gelca_p
gelcaps1235203gelcaps
gelding103911793gelding
gelled84718893gell_ed
gelt56448013ge_l__t
gent56954393ge___nt
gerent73223093ge_rent
german9611983german_
germane1049663germane
germans1079473germans
gestalt8411163gestalt
giant65430593g__iant
gilling93520383gilling
gillnet839733gillnet
gland75217713g__land
glans65125833g__lans
glean65818203g_lean_
gleans75014743g_leans
glint66830183g__lint
gloat65427683g_loa_t
grant64840023g__rant
gullet74924833gull_et
gulling94019563gulling
heliast10312073heliast
hellbent1345743hellbent
hellcat12410173hellcat
helling114623223helling
holland11349473holland
implant11311333implant
jellaba1643883jellaba
jelling153516613jelling
jessant1438443jessant
lallan63414173lallan_
lalland83810183lalland
lallans74113533lallans
leant56737783__leant
levant9314493le_vant
libellant1145693libellant
llano5910603__llano
meant76537213me__ant
mediant103516703mediant
melling102822623melling
peasant9314923peasant
peccant13311733peccant
pedant9319493pe_dant
pellet83326553pell_et
peltast9310513peltast
pendant10314853pendant
pennant9312493pennant
petulant1048793petulant
pieplant1268733pieplant
plant75437113__plant
pliant83918823_pliant
preplant12712913preplant
pulsant9310563pulsant
reblent9614253reblent
reboant9315093reboant
recant83228683re_cant
regnant8312843regnant
regrant8317323regrant
reland75920433re_land
relaxant1545843relaxant
relearnt849213relearnt
relent64431853re_lent
relevant1149243relevant
relleno796463relleno
reloan6415693reloan_
reloans7313133reloans
remnant9312633remnant
repellant1146823repellant
replan83215823replan_
replans92814943replans
replants102811243replants
reptant92817073reptant
saltant7316773saltant
sealants82610743sealants
seawant103613413seawant
secant84023293se_cant
sejant133114483se_jant
sejeant1489723sejeant
selling83225833selling
sellout7313583sellout
servant10313633servant
sextant142911963sextant
slant55238703__slant
telling83321083telling
tenant6322473te_nant
ululant747693ululant
ungallant1053313ungallant
valiant10314623valiant
verdant11313293verdant
versant10313833versant
volant9316323_volant
welling112920313welling
wetland1135353wetland
yelling113516703yelling

Search took 8 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.436409841.7
2DLD Change Limit1340271777.42318055.6
3Display Results1771770.0632809.5
 (SQL Overall)1786911777.92222556.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.