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

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

289 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
unpaid93947(None) 
unlaid7311751unlaid
unsaid7411831unsaid
inlaid7310132inlaid
nonpaid1048072nonpaid
paid75737482__paid
repaid94716322repaid
unai44824782un_ai_
unais53420772un_ais
unbid83214642un_bid
unbraid1037182unbraid
undid72415362un_did
unfair936232unfair
unhair937332unhair
unhand10410382unhand
unnail6410582unnail
unpack1457832unpack
unpaged113311042unpaged
unpaired11208942unpaired
unpaved133410052unpaved
unpin72613242unp_in
unplait948602unplait
unrepaid1143712unrepaid
afraid1049713afraid
aid49269073___aid
antacid10311203antacid
aphid115515393_aphid
bandaid11310473bandaid
braid85822263_braid
caid77837533__caid
capsid11312413capsid
cupid103212783cup_id
cuspid11429213cusp_id
elapid939543elapid
entail61114343entail
expand16236573expand
funfair1342033funfair
fungoid1245243fungoid
impair1036003impair
impavid1544543impavid
inland7310313inland
invalid1146373invalid
inward10310333inward
knead10429663knea_d
laid56439143__laid
lipid85916173lip_id
lipoid9411043lipoid
maid75537643__maid
naiad6313403_n_aiad
naif76839023_n_aif
nail45838653_n_ail
nard56634453_n_ard
navaid1037643navaid
nitid61817833_nitid
onward1039053onward
outlaid81110653outlaid
outsaid81210923outsaid
pad68057323__pa_d
padi76331783__padi
paik105726803__paik
pail66141833__pail
pain65647243__pain
pair66031513__pair
papain10313793papain
pard76441323__pard
pavid115717003__pavid
peptid112712373peptid
plaid85118303_plaid
prepaid12310133prepaid
qaid146023843__qaid
raid55243073__raid
rapid86422033rap_id
relaid75518443relaid
repair84011463repair
repand95316063repand
resaid74517083resaid
said55742113__said
sapid84720933sap_id
snail57020203sn_ail
spaed85522273_spaed
spail74921553_spail
spait75631603_spait
sparid94016933_sparid
staid66722073_staid
sulphid1346113sulphid
sunland837473sunland
sunward1137653sunward
taxpaid1743093taxpaid
tepid8314313tep_id
ulnad65611453ulna_d
ulpan7310123ulpa_n
ulpanim1143993ulpanim
umped104717273ump_ed
unafraid1242663unafraid
unaged83916423unaged
unaided92414603un_aided
unaimed102812493un_aimed
unaired82916013un_aired
unakin10310963unakin
unapt710421593un_apt
unarm7314453un_arm
unary8315993un_ary
unau43924153un_a_u
unaus53216573un_aus
unawed103914903unawed
unaxed144113093unaxed
unbaked143312893unbaked
unbale83616403unbale
unbaled103315963unbaled
unban72114333unba_n
unbans81912623unbans
unbar71913613unba_r
unbars82113033unbars
unbased103513483unbased
unbated103317733unbated
unbend9269773unbend
unbind93011433unbind
unbraids1144953unbraids
unbred92613303unbred
unbuild1035723unbuild
uncage93014873uncage
uncaged113314123uncaged
uncake122813523uncake
uncaked143514353uncaked
uncandid1244603uncandid
uncap9312283unca_p
uncaps1039813uncaps
uncase83817433uncase
uncased104216953uncased
uncast84215713uncast
unchain1238943unchain
unchair1236163unchair
unchic1338643unchic
unci65019463un_ci_
uncia75015163un_cia
unciae83215313unciae
uncial83715223uncial
unclad938913unclad
unclip1046993unclip
uncoil8811853uncoil
undated93118463undated
undead82711903undead
underpaid1346963underpaid
undried92314613undried
undyed1138143undyed
unease63816643unease
uneasy9278853uneasy
unfaded123111733unfaded
unfaith1345783unfaith
unfaked153211173unfaked
unfazed20299053unfazed
unfed94614223un_fed
unfit84518563un_fit
unfix15429033un_fix
unfold10179703unfold
unfond10149113unfond
ungated92717213ungated
ungird887973ungird
unguard955093unguard
unguis738453unguis
unhailed12219963unhailed
unhaired12238763unhaired
unhairs1036373unhairs
unhands1137773unhands
unhandy1445513unhandy
unhang1038443unhang
unhat81119263unha_t
unhats91110623unhats
unheard1136943unheard
unhip10178823un_hip
unhood1039233unhood
unific1137463unific
unified112413573unified
unipod946853unipod
unit45140073un__it
unitard838003unitard
united74421543united
unjaded16279143unjaded
unjam1448723unja_m
unjams1555703unjams
unkend11309223unkend
unkind113310573unkind
unknit1068593unknit
unlace82215173unlace
unlaced102913733unlaced
unlade72714153unlade
unladed92614373unladed
unlash938793unlash
unlay84613703unla_y
unlays93810493unlays
unlead73312373unlead
unled64021073un_led
unlit55025463un_lit
unload73010803unload
unmade92911063unmade
unmailed11229763unmailed
unmake122811213unmake
unman72715423unma_n
unmans82211993unmans
unmask1265903unmask
unmated103317023unmated
unmix14388973un_mix
unmold9148313unmold
unnailed9229443unnailed
unnails738223unnails
unnamed102410273unnamed
unpacked17268663unpacked
unpacks1576093unpacks
unpadded1345183unpadded
unpainted1237183unpainted
unparted11310823unparted
unpaying1456943unpaying
unpeg8309363unp_eg
unpegs9256233unpegs
unpen72913573unp_en
unpens82511013unpens
unpent83117373unpent
unpick1446903unpick
unpile81914323unpile
unpiled102312743unpiled
unpins82312383unpins
unpitied1138783unpitied
unplaced1338613unplaced
unplaited1236883unplaited
unplaits1044813unplaits
unplayed1437263unplayed
unplug954413unplug
unpoised1139183unpoised
unposed10711903unposed
unpriced1338143unpriced
unprimed1337193unprimed
unprized2038503unprized
unpure82911533unpure
unraised91811883unraised
unraked122914013unraked
unrated82621553unrated
unrazed172511453unrazed
unread73412673unread
unrepair1042373unrepair
unrig61711413un_rig
unrip72012863un_rip
unsafe9310693unsafe
unsated83419933unsated
unsaved113312193unsaved
unsawed112911503unsawed
unsawn9317463unsawn
unsay83212843unsa_y
unsays9399543unsays
unshed10313773unshed
unship1148033unship
unshod1067603unshod
unsold71410513unsold
unsolid8138373unsolid
unsplit956563unsplit
untack1239763untack
untame82513603untame
untamed102913223untamed
untaxed152710583untaxed
untidy1059153un_tidy
untie54425493un_tie
untied73720813untied
until53517743un_til
untold7149683untold
untried82615853untried
untrim8310673untrim
untrod769853untrod
unused72012883unused
unvaried1239683unvaried
unveil957343unveil
unwary1239823unwary
unwaxed18308393unwaxed
unwed94114873un_wed
unwind102610543unwind
unwit84417523un_wit
unzip16207623un_zip
upas68322383u_pa_s
upbind11246313u_pbind
upbraid1244973upbraid
upend85011043u_pend
upgird10103933u_pgird
upland938863upland
uplit76020803u_plit
upped103715163u_pped
upside9289803u_pside
upward12147163upward
upwind12255823u_pwind
urped84615283urp_ed
ursid6311483u_rsid
vapid115614283vap_id

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 Filter1786911127160.1231452772.4
2DLD Change Limit1127162897.47015089.2
3Display Results2892890.0933107.5
 (SQL Overall)1786912897.68623248.9
 
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.