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 “gaining” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

143 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
gaining9401566(None) 
gaiting93716581gaiting
graining102813181graining
paining103920241paining
raining83922691raining
saining83621391saining
aiding84423612_aiding
ailing74331012_ailing
aiming94320842_aiming
airing74927502_airing
alining81917042alining
awning105013392_awning
bailing103723522bailing
baiting103918882baiting
baning95127832ba_ning
banning103818232banning
barning104320352barning
braining113414682braining
brining103216472brining
cabining1338642cabining
caning94128622ca_ning
canning103620132canning
chaining142810782chaining
chining133316842chining
coining103920542coining
damning114211632damning
darning93817332darning
dawning124111012dawning
dining84525132_dining
draining103312672draining
dwining12269292dwining
earning83418212earning
failing113521332failing
fainting123312162fainting
fairing113614012fairing
fanning113615072fanning
fawning14409132fawning
fining104223212_fining
foining113013452foining
gabbing133512032gabbing
gabling113514542gabling
gadding113411452gadding
gaeing84617222ga_eing
gaffing15379732gaffing
gagging93013522gagging
gaging94718402ga_ging
gaijin1445982gaijin_
galling93921962galling
gaming104622042ga_ming
gamming133112622gamming
ganging103216192ganging
gaoling93314652gaoling
gaping105618922ga_ping
gapping134214782gapping
garbing113613272garbing
garring93116712garring
gashing125119232gashing
gasking134415912gasking
gasping113714362gasping
gassing94216332gassing
gasting95022762gasting
gating84826952ga_ting
gauging10339962gauging
gauming11319712gauming
gawking16398822gawking
gawping14418462gawping
gazing174717172ga_zing
gibing103712352g_ibing
gieing83614852g_ieing
ginning93313982ginning
girning93210692girning
giving114313882g_iving
glairing1047282glairing
gliding103911842gliding
gliming113310132gliming
glinting103210052glinting
gowning12258832gowning
griding103014972griding
griming113612492griming
grinding1139862grinding
grinning1037862grinning
griping113012062griping
groining102310632groining
guiding102911842guiding
guiling93214212guiling
guising93511412guising
gunning93413172gunning
hailing113820692hailing
jailing153415842jailing
joining153011482joining
lairing83715342lairing
lining74526802_lining
mailing102923342mailing
maiming122912722maiming
manning103616382manning
mining94225452_mining
nailing83419962nailing
opining10311742opining
paiking143814812paiking
painting113614422painting
pairing103716732pairing
panning104019392panning
patining11312302patining
pawning134711412pawning
peining104619152peining
pining93726532_pining
plaining113911552plaining
raiding93617592raiding
railing83325642railing
raising83220532raising
ravining12269692ravining
regaining112411082regaining
reining84425322reining
ruining83514882ruining
sailing83927372sailing
sainting93215732sainting
saning75127642sa_ning
seining84020772seining
shining113816522shining
staining9413372staining
tailing82923102tailing
tainting93613582tainting
tanning83618252tanning
tining74927542_tining
training93015862training
trining82919212trining
twining113211442twining
vailing113817942vailing
vanning113912462vanning
veining114713892veining
vining104619462_vining
waifing142910892waifing
wailing113620902wailing
wairing113414312wairing
waiting113618952waiting
waiving14329632waiving
waning103623802wa_ning
wanning113816212wanning
warning113717092warning
whining143311672whining
wining103625052_wining
yarning113512952yarning
yawning14378342yawning

Search took 4 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 Filter1786911076710.406440125.6
2DLD Change Limit1076711433.37331921.4
3Display Results1431430.0632269.8
 (SQL Overall)1786911433.84246509.9
 
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.