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

57 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
ghostlike174335(None) 
ghostlier1343342ghostlier
goatlike1346292g_oatlike
hoselike15179642_hoselike
boatlike1457963_boatlike
boltlike1436313_boltlike
dustlike1335363_dustlike
footlike1537253_footlike
frostline1245873frostline
ghastlier1342893ghastlier
ghostier1235383ghost_ier
ghosting1336463ghost_ing
ghostliest1453713ghostliest
ghostliness1542563ghostliness
ghostly14355103ghostl__y
ghostwrite1752063ghostwrite
ghoulie1144253gho_uli_e
giantlike1443263giantlike
globelike1643853globelike
gnatlike1334743g_natlike
gnomelike1643563gnomelike
goadlike1435883g_oadlike
godlike1387563g_o_dlike
gonglike1455423g_onglike
grasslike1443693grasslike
gutlike12308653g__utlike
hatlike143311713_h_atlike
hoblike16158303_ho_blike
hoelike141411163_ho_elike
hoglike15157733_ho_glike
homelike17179533_homelike
hoodlike1636563_hoodlike
hooflike1834853_hooflike
hooklike1435123_hooklike
hooplike1736773_hooplike
hornlike1536503_hornlike
horselike1646263_horselike
hostile10312553_host_ile
hotline10712343_ho_tline
husklike1433613_husklike
hutlike14349063_h_utlike
knotlike1143993kno_tlike
loftlike1534393_loftlike
mastlike1437863_mastlike
moatlike1446993_moatlike
mosslike1435453_mosslike
nestlike1236083_nestlike
noselike12158573_noselike
oatlike113412403__oatlike
poetlike1436733_poetlike
potlike13910123_po_tlike
rootlike1236613_rootlike
roselike12169183_roselike
sheetlike1644323sheetlike
thornlike1643003thornlike
vestlike1535393_vestlike
yeastlike1672993yeastlike

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 Filter1786911486410.1701051123.5
2DLD Change Limit148641577.59319576.1
3Display Results57570.0163562.5
 (SQL Overall)178691577.77922970.9
 
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.