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

73 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
parridges138455(None) 
parridge1254331parridge_
partridges1453051partridges
porridges1343911porridges
abridges1245302_abridges
carriages1238332carriages
cartridges1472832cartridges
marriages1247382marriages
parries93925842parri__es
partridge1362862partridge_
porridge1243762porridge_
abridge1135693_abridge_
abridged1343903_abridged
abridger1243803_abridger
abridgers1343293_abridgers
arranges939413_arranges
arrises71617583_arri_ses
arrives101311513_arri_ves
barrages11711093barr_ages
bridges113911333__bridges
carbides133111693carbid_es
carriage1137853carriage_
carries94328013carri__es
carrioles1169473carrioles
cartridge1372723cartridge_
earringed1144453earringed
earrings9299633earring_s
farsides1237993farsid_es
ferriages1345663ferriages
fridges12369483__fridges
hagrides1337623hagrid_es
hardedges1543633hardedges
harridans13154563harridans
harries103525503harri__es
hayrides1536883hayrid_es
langridges1342193langridges
marriage1147253marriage_
marries93825283marri__es
pairings11398313pairing_s
parades104121463pa_rad_es
paradigms1544653paradigms
paradises122513203paradises
paragoges1347253paragoges
parges94529543pa_r__ges
pargings123410163parging_s
paries84742513pa_ri__es
parietes10714543pa_rietes
parings104219213pa_ring_s
parises94827183pa_ri_ses
parishes13314753pa_rishes
parities10522973pa_rities
parkades1538273parkad_es
parkings153610683parking_s
parodies11313693pa_rodies
parricides1545553parricides
parried103615723parri__ed
parrier93717653parri__er
parriers103612903parri_ers
parring103222063parring__
parritches1743223parritches
particles1339803particles
parties93230863parti__es
partings113513733parting_s
parvises133911913parvi_ses
patriates11311363patriates
perfidies1546603perfidies
perries93226603perri__es
porridgy1542133porridg_y
porringer1244053porringer
porringers1343743porringers
prides94324183p__rid_es
ridges85817013___ridges
tarries73324263tarri__es

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.423422437.4
2DLD Change Limit148641737.28320409.3
3Display Results73730.0302433.3
 (SQL Overall)178691737.73623098.6
 
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.