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

120 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
ghibli124349(None) 
ghiblis1353341ghiblis
chili106218482chi_li
chilli114312772chilli
ghillie11326352ghillie
glibly1236292glibly
hili75626632_hi_li
aioli5318313_aioli
alibi7514223alib_i
alible8311973alible
biali73419073_biali
bible95119413_bible
ceili75814793cei_li
chablis14368553chablis
chichi1637093chichi
chicle134312543chicle
chicly16429203chicly
chiel104918973chiel_
chield124610213chield
chiels115115933chiels
child114516223chi_ld
chile105626893chi_le
chilis115517873chi_lis
chill105619873chi_ll
chillis124411603chillis
chills114717703chills
chilly144113223chilly
chimbly1974593chimbly
chimla1337593chimla
chitlin12269273chitlin
dhobi1136963dhob_i
edible969353edible
foible11410383foible
gabble113815723gabble
gable85325523g_able
gaily95020973gai_ly
gainly1049323gainly
gamble115417183gamble
garble94118453garble
gerbil938343gerbil
gharri10386163gharri
ghazi1837433gh_azi
ghi77019883gh___i
ghillies12408663ghillies
ghis85020163ghi__s
ghoul959053ghoul_
ghoulie1144253ghoulie
ghouls1036043ghouls
ghyll1246323gh_yll
ghylls1335143ghylls
gib66443523g_ib__
gibe75927773g_ib_e
gibed96215963g_ibed
giber85417703g_iber
gibes84422523g_ibes
giblet93418893g_iblet
gibs75529263g_ib_s
gild65526513g_i_ld
gill56336183g_i_ll
gillie74816943g_illie
gills64728193g_ills
gilly94321633g_illy
gilt56348543g_i_lt
girl56226553g_irl_
girlie73711463g_irlie
girls64518393g_irls
girly94415293g_irly
glial66715433glial_
glib79421433glib__
gobble113512983gobble
goblin939503g_oblin
gribble12297273gribble
grigri833853grigri
grill64617893gri_ll
grille74315743grille
grills74314803grills
grimly12459933grimly
grisly104310583grisly
guild75312753gui_ld
guile64521133gui_le
guilt65125573gui_lt
hila76228353_hi_la
hill76439493_hi_ll
hillo84721653_hillo
hills85431353_hills
hilly114422163_hilly
hilt75850713_hi_lt
hiply134113613_hiply
kibbi13449263_kibbi
kibei114311533_kibei
kibla1139833_kibla
libri74610113_libri
oribi7311083orib_i
phalli1148263phalli
phial10313203phial_
phials1158873phials
pili66130353_pi_li
shibah14387463shibah
shiel811023773shiel_
shield106212973shield
shiels95418923shiels
shill85325333shi_ll
shills94519603shills
shily115222013shi_ly
thalli958913thalli
thill85918733thi_ll
thills95515383thills
thimble1435863thimble
thinly1238663thinly
thiol87616043thiol_
thiolic1247303thiolic
thiols95112763thiols
thirl85416823thirl_
thirls95012063thirls
twibil1133563twibil
villi86517853_villi
while115418693whi_le
whirl114913823whirl_
whirls124710533whirls
whirly15448863whirly

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161207.11015853.2
3Display Results1201200.0333636.4
 (SQL Overall)1786911207.28324535.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.