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

89 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
piebald124550(None) 
piebalds1344341piebalds
pibal95217322pi_bal_
pibals103813082pi_bals
pinball1137932pinball
ribald9209292ri_bald
bald76432903___bald
bield84614653bie__ld
dieback1646913dieback
diehard1237053diehard
disband1138243disband
emerald1046923emerald
eyeball1245063eyeball
field95015323fie__ld
fireball13127263fireball
gimbal11228813gimbal_
gimbaled14104173gimbaled
gimbals12257823gimbals
herald10311343_herald
hiemal11339503hiemal_
imbalm1246323_imbalm
lienal63912783lienal_
peal68648103p_e_al_
pealed95322813p_e_aled
peals75235493p_e_als
pebble1238003p_ebble
pebbled1445403p_ebbled
pebbly1545083p_ebbly
pedal86022503p_edal_
pedaled113711893p_edaled
pedalo93811153p_edalo
pedals94316033p_edals
penal75228373p_enal_
petal76526893p_etal_
petaled103614153p_etaled
petals84719813p_etals
petard95013803p_etard
pial65636703pi__al_
pical95524373pi_cal_
pieced113912103pie_ced
pied75035363pie___d
piehole12188553piehole
pierced12347593pierced
pieta75421753pieta__
pietas84516503pieta_s
pinballed1444033pinballed
pinballs1246933pinballs
pineal84817683pineal_
pineals93212843pineals
pineland1145893pineland
pinfold1336233pinfold
pinnal84814273pinnal_
pinwale1257843pinwale
pipal95118353pi_pal_
pipals104213643pi_pals
pitfall1245823pitfall
plead85818463ple_a_d
pleiad947833pleia_d
plexal1536843plexal_
prebade12310283prebade
prebake1539093prebake
prebaked1737173prebaked
prebend12319443prebend
prebid113512843preb_id
prebill1138803prebill
prebind123810643prebind
preboard1338263preboard
prebuild1344303prebuild
premold1247863premold
prepaid12310133prepaid
presale9416353presale
presold1059603presold
pretold1049083pretold
proband122710243proband
pueblo1035553pueb_lo
ribalds10236673ri_balds
riband9239623ri_band
ribband1245583ribband
sideband1245023sideband
skewbald1842073skewbald
spitball1244493spitball
tieback1547103tieback
timbal102510753timbal_
timbale11248803timbale
timbals11239533timbals
weald95615023_we_ald
wideband1544453wideband
wield95213913wie__ld
yield9519693yie__ld

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 Filter1786911340270.420425454.8
2DLD Change Limit134027897.62617575.0
3Display Results89890.0302966.7
 (SQL Overall)178691898.07622126.2
 
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.