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

97 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
warship154783(None) 
wardship1744881wardship
warships1647551warships
worship1547831worship
airship1248512airship
arshin9312172_arshin
earlship1345102earlship
hardship1746032hardship
palship1446832palship
parsnip1146322parsnip
starship1348142starship
wardships1844582wardships
washup1435322wa_shup
worships1647102worships
airships1347713airships
archil11611573_archil
arshins10312573_arshins
arsis55722423_ars_is
banshie12129543banshie
barhop13319643bar_hop
carhop133610763car_hop
darshan1167063darshan
dashi95013113da_shi_
dashis104414393da_shis
deanship1446553deanship
earlships1444763earlships
earshot10410823earshot
fireship1646233fireship
flagship1743613flagship
godship1445083godship
gunship1345383gunship
guruship1443263guruship
hardships1845643hardships
harelip1245953harelip
harsh116418053harsh__
harshen1339283harshen
harsher13310363harsher
harshly1636273harshly
headship1745743headship
heirship1645053heirship
karstic1357983karstic
kinship1645823kinship
ladyship1743553ladyship
lairdship1553153lairdship
lordship1444413lordship
marsh105320853marsh__
marshal1238973marshal
marshes123615373marshes
marshier1337593marshier
marshy14558333marsh_y
mashie11315933ma_shie
mateship1546953mateship
mayorship1954613mayorship
midship1546043midship
ownership1754033ownership
palships1546213palships
parsnips1245533parsnips
preship1439793preship
reship11310673_reship
ship95228243___ship
sizarship2354183sizarship
sonship12108653sonship
starships1447663starships
tankship1744893tankship
tarsi55222173tars_i_
tarsia65514273tars_ia
tranship13410183tranship
twinship1644463twinship
unship1148033_unship
vicarship1954063vicarship
wardenship1963453wardenship
warmup1335343war_mup
warp95635003war___p
wars78659803wars___
warsaw1236193wars_aw
warsaws1335763warsaws
warsle93112923wars_le
warsled112910443warsled
warsler10289893warsler
warsles103413643warsles
warsling12198593warsling
warstle10328013warstle
warthog1444533warthog
wash106033813wa_sh__
washed135521503wa_shed
washer124720393wa_sher
washes124425493wa_shes
washier133611153wa_shier
washing145119283wa_shing
washups1534683wa_shups
washy145911843wa_sh_y
wasp95626853wa_s__p
wassail1056133wassail
whip125521843w___hip
workshop2043973workshop
worshiped1842803worshiped
worshiper1743113worshiper

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.423422437.4
2DLD Change Limit134027976.65620136.3
3Display Results97970.0303233.3
 (SQL Overall)178691977.10925135.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.