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 “parley” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
parley11671835(None) 
barley115116761barley
parlay113713991parlay
parle75836161parle_
parled94626281parled
parles86334401parles
parleys125212371parleys
parsley1247791parsley
agley96917332_agley
alley85721672_alley
arles56735742_arles
bailey115015672bailey
barely114716792barely
barleys125011842barleys
barney115314452barney
burley114715752burley
carle74535702carle_
carles85435082carles
carney115315702carney
charley15118272charley
darkey145212422darkey
early85324122earl_y
farle86929242farle_
farles96025782farles
galley104215452galley
garvey13127872garvey
hurley125012522hurley
jarvey19135402jarvey
marled95523162marled
marly106925612marl_y
pacey126720282pa_cey
padle84522342padle_
padles95221122padles
paisley1235552paisley
pale66055012pa_le_
palea75028662pa_lea
paled85538722pa_led
palely11311922pa_lely
paler75436932pa_ler
pales75753802pa_les
palet74650802pa_let
palled94625162palled
pallet84232652pallet
pally105727122pa_lly
palmy126016732pa_lmy
palsy105417462pa_lsy
paly95835532pa_l_y
parae76335702parae_
parcel103915472parcel
pardee93922022pardee
pardy115523952par_dy
pare66760842par_e_
pared86946762par_ed
pareo74632602par_eo
parer75839902par_er
pares77164482par_es
pareu74928742par_eu
parge85831852parge_
parged104922042parged
parges94529542parges
parget94529392parget
paries84742512paries
parity114719872parity
parked134425142parked
parker124121372parker
parlays123910452parlays
parleyed1436232parleyed
parleyer1335622parleyer
parlor8312672parlor
parody12410092parody
parole84425252parole_
paroled104217622paroled
parolee94119632parolee
paroles95025882paroles
parred95024072parred
parrel84515982parrel
parry105323752par_ry
parse75236992parse_
parsec105914482parsec
parsed96323892parsed
parser84822372parser
parses85534702parses
parsleys1335082parsleys
parted94228682parted
partlet92720362partlet
partly116315472partly
party106630612par_ty
parve109824852parve_
patly105020582patl_y
pearled10411542pearled
pearler9310372pearler
pearly116414842pearl_y
prey96228482p_r_ey
pulley113713402pulley
purely114013622purely
purled94520742purled
purvey14559572purvey
pusley11379612pusley
rarely93513652rarely
sparely123410672sparely
valley124311602valley
varlet9423502varlet
yarely122810302yarely

Search took 3 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 Filter178691825510.1261418182.5
2DLD Change Limit825511032.62331472.0
3Display Results1031030.0333121.2
 (SQL Overall)1786911032.78264231.1
 
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.