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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
ghiblis135334(None) 
ghibli1243491ghibli_
chablis14368552chablis
chilis115517872chi_lis
chillis124411602chillis
ghillie11326352ghillie
ghillies12408662ghillies
aiblins9311473_aiblins
aiolis6316843_aiolis
alibis8311073alib_is
bialis83617163_bialis
bibles104617643_bibles
biblist11310833_biblist
ceilis85413743cei_lis
challis124613463challis
chichis1737073chichis
chicles143512503chicles
chields13507483chields
chiels115115933chiel_s
chiles115425303chi_les
chili106218483chi_li_
chilies124218303chi_lies
chilli114312773chilli_
chillies134113483chillies
chills114717703chi_lls
chimblies1845023chimblies
chimlas1437453chimlas
chitlin12269273chitlin
chitlins13289393chitlins
dhobis1236103dhob_is
edibles1048003edibles
foibles1238853foibles
gabbles124415413gabbles
gables94222333g_ables
gambles124016203gambles
garbles104016923garbles
gerbils1037303gerbils
gharris11306433gharris
ghazis1935193gh_azis
ghis85020163gh___is
ghoulie1144253ghoulie
ghoulies1235393ghoulies
ghoulish1543543ghoulish
ghouls1036043ghoul_s
ghylls1335143gh_ylls
gibers95114663g_ibers
gibes84422523g_ib_es
giblet93418893g_iblet
giblets103210423g_iblets
gibs75529273g_ib__s
gilds75417523g_i_lds
gillie74816943g_illie
gillies84120963g_illies
gills64728193g_i_lls
gilts64924263g_i_lts
girlie73711463g_irlie
girlies83013703g_irlies
girlish1137193g_irlish
girls64518393g_irl_s
glibly1236293glibl_y
gobbles123512583gobbles
goblin939503g_oblin
goblins1039243g_oblins
gribbles13307363gribbles
grigris934093grigris
grilles83715023grilles
grills74314803gri_lls
guilds8388353gui_lds
guiles73919283gui_les
guilts74111233gui_lts
hili75626633_hi_li_
hillos94618883_hillos
hills85431353_hi_lls
hilts86924413_hi_lts
hilus84817643_hi_lus
hubris11218973_hubris
hybris14247003_hybris
ibis66519583__ib_is
kibbis14398473_kibbis
kibeis12469803_kibeis
kiblas1239323_kiblas
oribis838833orib_is
phials1158873phial_s
pilis75825203_pi_lis
shibahs15275643shibahs
shields11538043shields
shiels95418923shiel_s
shills94519603shi_lls
shitlist1148713shitlist
thills95515383thi_lls
thimbles1536013thimbles
thiolic1247303thiolic
thiols95112763thiol_s
thirls95012063thirl_s
twibils1253113twibils
whiles124418013whi_les
whirlies14167373whirlies
whirls124710533whirl_s

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.1561145455.1
2DLD Change Limit134027987.15618729.3
3Display Results98980.0303266.7
 (SQL Overall)178691987.34224338.2
 
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.