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

66 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
parroket144921(None) 
parrokets1543921parrokets
parrakeet1545602parrakeet
parrot8320662parro__t
parroted1158852parroted
parroter1058212parroter
arrowed1148133_arrowed
baronet91022213ba_ronet
barret84930493barr__et
carromed1338573carromed
carrot8423123carro__t
farrowed1545303farrowed
garret74426563garr__et
garrote8510113garrote_
garroted1056793garroted
garroter956593garroter
garrotes969383garrotes
garrotte965693garrotte
harrowed1556283harrowed
harrower1446373harrower
karaoke1044903karaoke_
karaokes1145013karaokes
market123226043ma_r_ket
marmoset12411983marmoset
marrowed1445993marrowed
narrowed1235233narrowed
narrower1145073narrower
narrowest1244293narrowest
packet144726503pa__cket
padrone102512073padrone_
padrones112711043padrones
parakeet14410523parakeet
parapet11317643pa_rapet
paraquet1948793paraquet
parbake1538353parbake_
parbaked1735503parbaked
parbakes1638343parbakes
pardoned12189333pardoned
pardoner11189443pardoner
parget94529393pa_r_get
parked134425143pa_r_ked
parker124121373pa_r_ker
parole84425253pa_role_
paroled104217633pa_roled
parolee94119653pa_rolee
paroles95025893pa_roles
paroquet1947283paroquet
parquet18311583pa_rquet
parrakeets1652363parrakeets
parred95024073parr__ed
parrel84515983parr__el
parried103615723parr_ied
parrier93717653parr_ier
parries93925853parr_ies
parroters1156773parroters
parrots9312743parro_ts
parroty1247863parro_ty
partake1339643partake_
partaken1445553partaken
partaker1436873partaker
partakes1449923partakes
partlet92720363pa_rtlet
pricket153616443p_ricket
projet15315183p__rojet
pyrrole1246033pyrrole_
pyrroles1345453pyrroles

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 Filter1786911461620.436409841.7
2DLD Change Limit146162666.96620982.2
3Display Results66660.0164125.0
 (SQL Overall)178691667.41824088.8
 
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.