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

79 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
palship144683(None) 
palships1546211palships
earlship1345102earlship
parsnip1146322parsnip
preship1439792preship
warship1547832warship
airship1248513airship
arshin9312173_arshin
banshie12129543banshie
bolshie1247123bolshie
dashi95013113da_shi_
dashis104414393da_shis
deanship1446553deanship
earlships1444763earlships
falsie93513853fals_ie
flagship1743613flagship
godship1445083godship
gunship1345383gunship
hardship1746033hardship
headship1745743headship
kinship1645823kinship
ladyship1743553ladyship
mashie11315933ma_shie
mateship1546953mateship
midship1546043midship
padshah16113353padshah
paladin101011773paladin
palais8420423pal_ais
palish114718273palish__
pallia83015593pal_lia
pallid93915283pal_lid
palmtop1343873palmtop
palp85828573pal___p
palpi95414553pal_pi_
pals66951353pals___
palsied102911303palsied
palsies94420273palsies
palsy105417463pals__y
palsying1436233palsying
parsnips1245533parsnips
pash95638133pa_sh__
pasha105417183pa_sh_a
pashas115117063pa_shas
pashed125923143pa_shed
pashes115828393pa_shes
pashing135120513pa_shing
passim10410283pa_ssim
pastie85525523pa_stie
pastil85018323pa_stil
pastis84924323pa_stis
pawnshop18102563pawnshop
plash104616563plash__
plashed133712643plashed
plasher124215033plasher
plashes124417393plashes
plashier1337613plashier
plashing143311063plashing
plashy14448873plash_y
plasmic13249113plasmic
plasmid12239553plasmid
plasmin112410033plasmin
plastic112815063plastic
plastid102112523plastid
preships1539313preships
pushup1335273p_ushup
reship11310673_reship
ship95228233___ship
skaldship1952263skaldship
sonship12108653sonship
spaceship1853743spaceship
starship1348143starship
tankship1744893tankship
tranship13410183tranship
unship1148033_unship
upmanship1854003upmanship
wardship1744883wardship
warships1647553warships
washup1435323wa_shup
worship1547833worship

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 Limit134027797.26618445.8
3Display Results79790.0136076.9
 (SQL Overall)178691797.43524033.8
 
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.