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

54 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
porridges134391(None) 
parridges1384551parridges
porridge1243761porridge_
parridge1254332parridge_
partridges1453052partridges
porridgy1542132porridg_y
porringer1244052porringer
porringers1343742porringers
abridges1245303_abridges
borides10515153bo_rid_es
bourrides1244823bourrid_es
bridges113911333__bridges
browridges1791333browridges
carriages1238333carriages
cartridges1472833cartridges
corrades111211263corrad_es
corridas1177313corrid_as
corridors1245073corridors
corries94026793corri__es
corrodes111310333corrod_es
corrodies1247903corrodies
ferriages1345663ferriages
forjudges2142053forjudges
fridges12369483__fridges
horribles14113973horribles
horrider1236533horrid_er
horridest1345643horrid_est
horridness1443843horridness
horrifies15146393horrifies
joyrides1943853joyrid_es
lorries74518343lorri__es
marriages1247383marriages
morrises10711073morri_ses
oreides8312023_oreid_es
oroides8311973_oroid_es
orrices9129363_orri_ces
orrises71312233_orri_ses
parries93925843parri__es
partridge1362863partridge_
perfidies1546603perfidies
perries93226603perri__es
porgies103017003porgi__es
porkies133416493porki__es
portages112613223po_rtages
porticoes1348253porticoes
portieres1138213portieres
prides94324183p__rid_es
provides1439883provid_es
ridges85817003___ridges
torrider936173torrid_er
torridest1045753torrid_est
torridness1164093torridness
torrifies12137033torrifies
worries104117133worri__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.1561145455.1
2DLD Change Limit148641547.70319296.5
3Display Results54540.0331636.4
 (SQL Overall)178691547.89222642.0
 
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.