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

82 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
campsites154647(None) 
campsite1447411campsite_
amosites10311232_amosites
campfires1844122campfires
camphines1847562camphines
camphires1845782camphires
capsizes2147202ca_psizes
composites1648902composites
dumpsites1443762dumpsites
adamsites1243513adam_sites
amosite9313163_amosite_
aplites9314933_a_plites
apsides103911303_a_psides
calamites13410713calamites
calcites12313003ca_lcites
camases114216343camas__es
camasses12388973camas_ses
cambists1437023cambist_s
camisades1474963camisades
camises114218463cam__ises
camisias12268603camisi_as
camisoles1345583camisoles
cammies134016483cam_mi_es
camomiles15155633camomiles
campaigns1643473campaigns
campaniles1644113campaniles
campesinos1642433campesinos
campfire1744023campfire_
camphenes1846463camphenes
camphine1738373camphine_
camphire1745893camphire_
campier133313273camp_i_er
campiest142212143camp_i_est
campiness1537543camp_iness
campings154010203camp_ings
campions143511293camp_ions
camporees1546103camporees
campouts1436823campout_s
campshirts1952103campshirts
campuses1437773camp_uses
capizes20410373ca_p_izes
capotes11314643ca_p_otes
caprices1439893ca_prices
capsids1239333ca_psi_ds
capsize2037623ca_psize_
capsized2255503ca_psized
capsules1236633ca_psules
captives1538623ca_ptives
casitas93312043ca__sitas
cassines103116613ca_ssines
cassises103811743ca_ssises
castes85631863ca__s_tes
catamites1349363catamites
cerusites1146523cerusites
coesites101313093c_oesites
competes144117243comp_etes
compiles14311983comp_iles
completes153212923completes
complices1739253complices
complies14314523compli_es
complines15312833complines
composite15410153composite_
composited1756003composited
compotes144716513comp_otes
comprises15510943comprises
comprizes2468943comprizes
computes143914553comp_utes
crampits1436273cramp_it_s
cuprites1259023c_uprites
dumpsite1344293dumpsite_
haplites1339993ha_plites
homesites1448923homesites
jarosites1647373jarosites
kamacites1744523kamacites
parasites11313163parasites
ramosities1246873ramosities
rampikes1635393ramp_ikes
samites93118713sam__ites
samphires1645513samphires
scampies1439333scamp_i_es
vampires15226033vamp_ires
wampishes1944303wampishes

Search took 10 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.843211970.3
2DLD Change Limit148641828.42317647.0
3Display Results82820.0302733.3
 (SQL Overall)178691829.29619222.4
 
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.