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

104 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
ghostings143348(None) 
ghosting1336461ghosting_
frostings1335732frostings
goslings10297552g_oslings
hosting114318382_hosting_
hustings12378682_hustings
postings112912302_postings
shootings13266062shootings
bastings114214693_bastings
beastings12387653beastings
beestings12335923beestings
biestings12266033biestings
blastings12347913blastings
boatings113710113_boatings
boosting113311053boosting_
castings113614053_castings
chasings14318253chas_ings
closings11277673clos_ings
coastings12357863coastings
coatings113811843_coatings
cohosting1546323cohosting_
costing104323023_costing_
crestings12298043crestings
crossings12217163crossings
dustings10419033_dustings
eastings93412953_eastings
fastings124011943_fastings
footings12248833_footings
frosting12311183frosting_
gaskings14427473g_askings
gassings10438403g_assings
gasting95022763g_asting_
gatings95212823g__atings
ghostier1235383ghosti_er
ghostiest1336543ghostiest
ghostliness1542563ghostliness
ghosts10489273ghost___s
gloamings13254093gloamings
gloating102611463gloating_
gloomings13283973gloomings
glossinas10214143glossinas
glossing10278883glossing_
glouting10379693glouting_
gnostics1146323gnosti_cs
godlings11367493g_odlings
goings84911523g_o__ings
golfings13304873g_olfings
goosing93314083goos_ing_
gosling93312403g_osling_
gratings103910763g_ratings
greetings11276043greetings
grossing103111063grossing_
groupings13273813groupings
grouting103410793grouting_
guesting1058463guesting_
gusting93917163g_usting_
hasting114725193_hasting_
hissings12556753_hissings
histing113720373_histing_
hoisting123610903_hoisting_
holdings13297743_holdings
hooting113919883_hooting_
hoppings16306523_hoppings
hornings12238363_hornings
hosing103421103_hos_ing_
hostiles11312213_hostiles
hotting113116523_hotting_
housings12307483_housings
huntings12328053_huntings
huskings16276043_huskings
jestings16368023_jestings
jottings16275193_jottings
knottings14243073knottings
lastings94214423_lastings
listings93310043_listings
losings82810623_los_ings
moshings14367333_moshings
nosings8349593_nos_ings
outings84014753__outings
posting105622243_posting_
postins93721203_postin_s
roosting93411463roosting_
scoutings12306143scoutings
shaftings16224183shaftings
sheetings13256713sheetings
shirtings13276603shirtings
shoestrings1542653shoestrings
shooting122812863shooting_
shoppings17295073shoppings
shorings12269483sho_rings
shorting122514803shorting_
shotting123012383shotting_
shouting122711793shouting_
showings15246883sho_wings
showrings1644063showrings
spoutings12245153spoutings
stings76220183___stings
twistings13264353twistings
vestings12359143_vestings
waistings1352710763waistings
westings12429803_westings
whisting15329543whisting_
whistlings1742913whistlings
whitings15287063wh_itings

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.453394461.4
2DLD Change Limit1486411047.43619989.4
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.93522519.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.