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

44 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
larrupers114252(None) 
larruper1042751larruper_
larruped1142872larrupe_d
larrups934732larrup__s
arguers8489033_argu_ers
arousers84810983_arousers
arrayers11125853_arrayers
arrivers11137003_arrivers
barraters1138043barraters
barriers104311893barr_iers
carousers1156743carousers
carpers114521253ca_r_pers
carriers103614203carr_iers
corrupters1444033corrupters
farriers113610743farr_iers
garroters1055823garroters
groupers11358643_groupers
harpers124916203ha_r_pers
harriers113712433harr_iers
harrowers1555693harrowers
labourers1144713labourers
lacquers19125033lacqu_ers
lampers113817333la__mpers
lappers113717463la__ppers
larceners1136003larceners
larders83516943la_r_ders
larkers113014513la_r_kers
larkspurs1551303larkspurs
larrup835713larrup___
larruping1243243larruping
lauders84012893la__uders
marauders1244263marauders
marrers93414313marr__ers
marriers103312473marr_iers
narraters946703narraters
parriers103612913parr_iers
parroters1156773parroters
paupers114311073pa__upers
tarpapers1344273tarpapers
tarriers83411713tarr_iers
troupers10359443_troupers
warpers123413583wa_r_pers
warreners1236203warreners
yaupers12337663ya__upers

Search took 9 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 Limit148641448.15618224.7
3Display Results44440.0133384.6
 (SQL Overall)178691448.59220797.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.